PREVIEW / etf_30min / 2012-05-14

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-14.parquet
  size:    293 KB
  rows:    9,991

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-05-14 04:00:00	SPY	ETF	134.61	134.75	134.3	134.31	15385.0
2012-05-14 04:30:00	SPY	ETF	134.32	134.32	134.28	134.29	3000.0
2012-05-14 05:00:00	SPY	ETF	134.28	134.57	134.28	134.55	2295.0
2012-05-14 05:30:00	SPY	ETF	134.55	134.55	134.39	134.54	45300.0
2012-05-14 06:00:00	SPY	ETF	134.51	134.55	134.31	134.5	20650.0
2012-05-14 06:30:00	SPY	ETF	134.54	134.54	134.27	134.27	58650.0
2012-05-14 07:00:00	SPY	ETF	134.24	134.5	134.15	134.5	331613.0
2012-05-14 07:30:00	SPY	ETF	134.5	134.59	134.4	134.5	288723.0
2012-05-14 08:00:00	SPY	ETF	134.53	135.17	134.32	134.42	632151.0
2012-05-14 08:30:00	SPY	ETF	134.42	134.44	134.25	134.4	531317.0
2012-05-14 09:00:00	SPY	ETF	134.41	134.47	134.29	134.31	586039.0
2012-05-14 09:30:00	SPY	ETF	134.31	134.61	134.03	134.27	21052818.0
2012-05-14 10:00:00	SPY	ETF	134.2725	134.33	133.91	133.96	17033642.0
2012-05-14 10:30:00	SPY	ETF	133.953	134.53	133.92	134.34	12923919.0
2012-05-14 11:00:00	SPY	ETF	134.34	134.92	134.25	134.74	13958472.0
2012-05-14 11:30:00	SPY	ETF	134.75	134.84	134.53	134.64	10980619.0
2012-05-14 12:00:00	SPY	ETF	134.65	134.81	134.57	134.7	4407222.0
2012-05-14 12:30:00	SPY	ETF	134.7	134.85	134.655	134.71	4828838.0
2012-05-14 13:00:00	SPY	ETF	134.72	134.82	134.4607	134.54	5409237.0
2012-05-14 13:30:00	SPY	ETF	134.55	135.03	134.52	134.9	7030252.0
2012-05-14 14:00:00	SPY	ETF	134.89	135.01	134.73	134.831	5910083.0
2012-05-14 14:30:00	SPY	ETF	134.831	134.88	134.34	134.42	6688248.0
2012-05-14 15:00:00	SPY	ETF	134.415	135.6144	134.23	134.3	12007135.0
2012-05-14 15:30:00	SPY	ETF	134.292	134.43	134.06	134.14	19059646.0
2012-05-14 16:00:00	SPY	ETF	134.13	134.4244	133.92	134.0	16488841.0
2012-05-14 16:30:00	SPY	ETF	134.01	134.3797	133.8	133.92	565119.0
2012-05-14 17:00:00	SPY	ETF	133.93	134.13	133.93	133.99	99489.0
2012-05-14 17:30:00	SPY	ETF	133.97	134.08	133.97	134.06	95545.0
2012-05-14 18:00:00	SPY	ETF	134.04	134.14	134.0	134.13	267781.0
2012-05-14 18:30:00	SPY	ETF	134.14	134.24	134.1	134.22	183861.0
2012-05-14 19:00:00	SPY	ETF	134.22	134.28	134.2	134.28	168121.0
2012-05-14 19:30:00	SPY	ETF	134.28	134.34	134.21	134.27	113804.0
2012-05-14 04:00:00	QQQ	ETF	63.78	63.78	63.7	63.7	1200.0
2012-05-14 04:30:00	QQQ	ETF	63.57	63.57	63.57	63.57	500.0
2012-05-14 05:00:00	QQQ	ETF	63.72	63.72	63.72	63.72	1200.0
2012-05-14 06:00:00	QQQ	ETF	63.66	63.66	63.58	63.66	7300.0
2012-05-14 06:30:00	QQQ	ETF	63.67	63.67	63.58	63.58	20900.0
2012-05-14 07:00:00	QQQ	ETF	63.58	63.68	63.52	63.66	53360.0
2012-05-14 07:30:00	QQQ	ETF	63.68	63.73	63.65	63.69	83990.0
2012-05-14 08:00:00	QQQ	ETF	63.7	63.75	63.63	63.64	280426.0
2012-05-14 08:30:00	QQQ	ETF	63.63	63.67	63.58	63.65	87335.0
2012-05-14 09:00:00	QQQ	ETF	63.65	63.71	63.62	63.63	329596.0
2012-05-14 09:30:00	QQQ	ETF	63.63	63.83	63.58	63.71	6000462.0
2012-05-14 10:00:00	QQQ	ETF	63.712	63.75	63.48	63.52	6217739.0
2012-05-14 10:30:00	QQQ	ETF	63.51	63.83	63.49	63.74	4296197.0
2012-05-14 11:00:00	QQQ	ETF	63.74	64.06	63.65	63.94	4597294.0
2012-05-14 11:30:00	QQQ	ETF	63.94	63.9999	63.86	63.94	2280946.0
2012-05-14 12:00:00	QQQ	ETF	63.95	64.03	63.88	63.9576	1629436.0
2012-05-14 12:30:00	QQQ	ETF	63.96	63.98	63.89	63.92	967685.0
2012-05-14 13:00:00	QQQ	ETF	63.9187	63.9814	63.73	63.79	1373494.0

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

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