PREVIEW / etf_30min / 2012-02-15

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-15.parquet
  size:    293 KB
  rows:    9,810

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
2012-02-15 04:00:00	SPY	ETF	135.7	136.0	135.7	136.0	21383.0
2012-02-15 04:30:00	SPY	ETF	136.0	136.05	135.96	136.01	117516.0
2012-02-15 05:00:00	SPY	ETF	136.03	136.14	136.03	136.12	7020.0
2012-02-15 05:30:00	SPY	ETF	136.1	136.1	135.91	135.93	10150.0
2012-02-15 06:00:00	SPY	ETF	135.96	136.02	135.96	136.02	2700.0
2012-02-15 06:30:00	SPY	ETF	136.02	136.13	135.98	136.05	192030.0
2012-02-15 07:00:00	SPY	ETF	135.99	136.19	135.95	136.19	390937.0
2012-02-15 07:30:00	SPY	ETF	136.18	136.23	136.0	136.0	551800.0
2012-02-15 08:00:00	SPY	ETF	136.0	136.17	135.52	135.85	2354815.0
2012-02-15 08:30:00	SPY	ETF	135.85	135.92	135.62	135.68	1306232.0
2012-02-15 09:00:00	SPY	ETF	135.68	135.89	135.62	135.63	1339928.0
2012-02-15 09:30:00	SPY	ETF	135.63	135.71	135.27	135.52	20571441.0
2012-02-15 10:00:00	SPY	ETF	135.52	135.64	135.23	135.43	13394588.0
2012-02-15 10:30:00	SPY	ETF	135.44	135.67	135.33	135.41	12402447.0
2012-02-15 11:00:00	SPY	ETF	135.405	135.65	135.35	135.65	11557263.0
2012-02-15 11:30:00	SPY	ETF	135.64	135.83	135.56	135.78	8334455.0
2012-02-15 12:00:00	SPY	ETF	135.77	135.79	135.6	135.62	6292285.0
2012-02-15 12:30:00	SPY	ETF	135.615	135.64	134.94	135.02	17164742.0
2012-02-15 13:00:00	SPY	ETF	135.01	135.09	134.7	135.06	14810988.0
2012-02-15 13:30:00	SPY	ETF	135.06	135.14	134.82	135.12	8159136.0
2012-02-15 14:00:00	SPY	ETF	135.13	135.21	134.58	134.96	17695818.0
2012-02-15 14:30:00	SPY	ETF	134.97	134.99	134.45	134.4701	12333052.0
2012-02-15 15:00:00	SPY	ETF	134.47	134.6	134.29	134.46	15041335.0
2012-02-15 15:30:00	SPY	ETF	134.46	134.79	134.37	134.56	20944964.0
2012-02-15 16:00:00	SPY	ETF	134.55	135.8065	134.21	134.64	6344217.0
2012-02-15 16:30:00	SPY	ETF	134.64	134.66	134.38	134.4	2519952.0
2012-02-15 17:00:00	SPY	ETF	134.4	134.5	134.38	134.46	88040.0
2012-02-15 17:30:00	SPY	ETF	134.46	134.48	134.4	134.4	40050.0
2012-02-15 18:00:00	SPY	ETF	134.39	134.4	134.3	134.35	103206.0
2012-02-15 18:30:00	SPY	ETF	134.35	134.39	134.33	134.37	18733.0
2012-02-15 19:00:00	SPY	ETF	134.37	134.38	134.13	134.17	261625.0
2012-02-15 19:30:00	SPY	ETF	134.19	134.33	134.19	134.29	313579.0
2012-02-15 04:00:00	QQQ	ETF	63.44	63.6	63.44	63.6	1500.0
2012-02-15 05:00:00	QQQ	ETF	63.62	63.67	63.62	63.67	700.0
2012-02-15 06:00:00	QQQ	ETF	63.59	63.62	63.59	63.62	1050.0
2012-02-15 06:30:00	QQQ	ETF	63.62	63.63	63.61	63.62	2770.0
2012-02-15 07:00:00	QQQ	ETF	63.6	63.68	63.6	63.68	44625.0
2012-02-15 07:30:00	QQQ	ETF	63.68	63.7	63.6	63.61	129552.0
2012-02-15 08:00:00	QQQ	ETF	63.62	63.65	63.49	63.61	2243496.0
2012-02-15 08:30:00	QQQ	ETF	63.61	63.61	63.48	63.49	1464568.0
2012-02-15 09:00:00	QQQ	ETF	63.5	63.61	63.5	63.53	663295.0
2012-02-15 09:30:00	QQQ	ETF	63.53	63.58	63.4	63.58	7609652.0
2012-02-15 10:00:00	QQQ	ETF	63.58	63.65	63.44	63.54	4897359.0
2012-02-15 10:30:00	QQQ	ETF	63.55	63.78	63.55	63.631	3804139.0
2012-02-15 11:00:00	QQQ	ETF	63.64	63.77	63.62	63.77	3225760.0
2012-02-15 11:30:00	QQQ	ETF	63.765	63.86	63.7114	63.85	3100073.0
2012-02-15 12:00:00	QQQ	ETF	63.85	63.855	63.67	63.67	3811078.0
2012-02-15 12:30:00	QQQ	ETF	63.6701	63.69	63.14	63.21	12490716.0
2012-02-15 13:00:00	QQQ	ETF	63.2	63.3	62.97	63.28	6704392.0
2012-02-15 13:30:00	QQQ	ETF	63.28	63.3	63.065	63.28	4025917.0

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

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