PREVIEW / etf_30min / 2011-08-15

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-15.parquet
  size:    293 KB
  rows:    9,831

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-08-15 04:00:00	SPY	ETF	119.0	119.0	118.77	118.99	12914.0
2011-08-15 04:30:00	SPY	ETF	118.9	119.07	118.89	119.07	3300.0
2011-08-15 05:00:00	SPY	ETF	119.11	119.11	119.04	119.04	3100.0
2011-08-15 05:30:00	SPY	ETF	118.92	118.94	118.62	118.74	5615.0
2011-08-15 06:00:00	SPY	ETF	118.69	118.69	118.42	118.64	3800.0
2011-08-15 06:30:00	SPY	ETF	118.64	118.84	118.46	118.82	20400.0
2011-08-15 07:00:00	SPY	ETF	118.78	118.84	118.7	118.79	88149.0
2011-08-15 07:30:00	SPY	ETF	118.79	118.9	118.63	118.85	150493.0
2011-08-15 08:00:00	SPY	ETF	118.87	119.04	118.67	118.69	681859.0
2011-08-15 08:30:00	SPY	ETF	118.73	118.89	118.49	118.68	1660658.0
2011-08-15 09:00:00	SPY	ETF	118.66	119.2	118.12	119.18	2266950.0
2011-08-15 09:30:00	SPY	ETF	119.19	119.9	119.11	119.62	30823958.0
2011-08-15 10:00:00	SPY	ETF	119.62	120.23	119.5	120.16	22670129.0
2011-08-15 10:30:00	SPY	ETF	120.15	120.25	119.64	119.68	18019284.0
2011-08-15 11:00:00	SPY	ETF	119.68	120.142	119.14	119.33	14373811.0
2011-08-15 11:30:00	SPY	ETF	119.3286	119.54	119.0	119.412	15193343.0
2011-08-15 12:00:00	SPY	ETF	119.43	119.69	119.36	119.6	7540040.0
2011-08-15 12:30:00	SPY	ETF	119.605	120.0	119.48	119.91	10130914.0
2011-08-15 13:00:00	SPY	ETF	119.92	120.11	119.61	119.86	13768392.0
2011-08-15 13:30:00	SPY	ETF	119.88	120.05	119.71	119.99	9821905.0
2011-08-15 14:00:00	SPY	ETF	119.99	120.39	119.95	120.32	11999579.0
2011-08-15 14:30:00	SPY	ETF	120.31	120.42	120.08	120.36	15861499.0
2011-08-15 15:00:00	SPY	ETF	120.355	120.55	120.14	120.21	13065456.0
2011-08-15 15:30:00	SPY	ETF	120.21	120.74	120.16	120.67	36327177.0
2011-08-15 16:00:00	SPY	ETF	120.66	120.7128	119.87	120.21	24900506.0
2011-08-15 16:30:00	SPY	ETF	120.21	120.36	120.11	120.33	2826198.0
2011-08-15 17:00:00	SPY	ETF	120.32	120.35	120.28	120.3	184171.0
2011-08-15 17:30:00	SPY	ETF	120.29	120.35	120.27	120.31	34740.0
2011-08-15 18:00:00	SPY	ETF	120.27	120.55	120.12	120.15	186187.0
2011-08-15 18:30:00	SPY	ETF	120.17	120.25	120.16	120.17	50011.0
2011-08-15 19:00:00	SPY	ETF	120.2	120.24	120.15	120.16	38375.0
2011-08-15 19:30:00	SPY	ETF	120.16	120.2	120.1	120.15	233360.0
2011-08-15 04:00:00	QQQ	ETF	53.84	53.84	53.74	53.74	1098.0
2011-08-15 04:30:00	QQQ	ETF	53.84	53.84	53.74	53.74	1098.0
2011-08-15 05:00:00	QQQ	ETF	53.84	53.84	53.84	53.84	2000.0
2011-08-15 05:30:00	QQQ	ETF	53.85	53.85	53.71	53.71	2600.0
2011-08-15 06:30:00	QQQ	ETF	53.62	53.75	53.62	53.75	2200.0
2011-08-15 07:00:00	QQQ	ETF	53.76	53.79	53.71	53.75	9400.0
2011-08-15 07:30:00	QQQ	ETF	53.76	53.79	53.65	53.7	97700.0
2011-08-15 08:00:00	QQQ	ETF	53.69	53.9	53.65	53.81	219297.0
2011-08-15 08:30:00	QQQ	ETF	53.64	53.71	53.51	53.59	340812.0
2011-08-15 09:00:00	QQQ	ETF	53.59	53.85	53.59	53.77	386493.0
2011-08-15 09:30:00	QQQ	ETF	53.77	54.21	53.73	54.01	10182542.0
2011-08-15 10:00:00	QQQ	ETF	54.02	54.26	53.95	54.2291	7336836.0
2011-08-15 10:30:00	QQQ	ETF	54.24	54.28	54.03	54.04	5493762.0
2011-08-15 11:00:00	QQQ	ETF	54.03	54.09	53.61	53.68	4772818.0
2011-08-15 11:30:00	QQQ	ETF	53.68	53.81	53.53	53.74	3804783.0
2011-08-15 12:00:00	QQQ	ETF	53.75	53.88	53.7	53.79	2662693.0
2011-08-15 12:30:00	QQQ	ETF	53.79	53.98	53.72	53.94	2126417.0
2011-08-15 13:00:00	QQQ	ETF	53.94	54.02	53.77	53.92	3164715.0

> showing 50 of 9,831 rows — these rows as CSV

> unlock the full archive -- $79 one-time