PREVIEW / etf_30min / 2012-04-24

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-24.parquet
  size:    279 KB
  rows:    9,419

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-04-24 04:00:00	SPY	ETF	137.25	137.26	137.25	137.26	200.0
2012-04-24 04:30:00	SPY	ETF	137.32	137.32	137.32	137.32	800.0
2012-04-24 05:00:00	SPY	ETF	137.32	137.32	137.32	137.32	10200.0
2012-04-24 06:00:00	SPY	ETF	137.22	137.22	137.12	137.12	400.0
2012-04-24 06:30:00	SPY	ETF	137.19	137.29	137.14	137.26	4100.0
2012-04-24 07:00:00	SPY	ETF	137.22	137.35	137.19	137.25	67965.0
2012-04-24 07:30:00	SPY	ETF	137.22	137.34	137.18	137.25	145550.0
2012-04-24 08:00:00	SPY	ETF	137.24	137.43	136.97	137.01	504594.0
2012-04-24 08:30:00	SPY	ETF	137.01	137.02	136.73	136.75	868930.0
2012-04-24 09:00:00	SPY	ETF	136.75	136.94	136.64	136.91	1191733.0
2012-04-24 09:30:00	SPY	ETF	136.91	137.19	136.8	136.95	19663175.0
2012-04-24 10:00:00	SPY	ETF	136.95	137.59	136.9	137.368	18667727.0
2012-04-24 10:30:00	SPY	ETF	137.37	137.58	137.32	137.51	6754602.0
2012-04-24 11:00:00	SPY	ETF	137.5098	137.66	137.31	137.58	11978382.0
2012-04-24 11:30:00	SPY	ETF	137.59	137.6	137.33	137.41	6998023.0
2012-04-24 12:00:00	SPY	ETF	137.41	137.49	137.34	137.42	3263943.0
2012-04-24 12:30:00	SPY	ETF	137.42	137.47	137.11	137.135	6658917.0
2012-04-24 13:00:00	SPY	ETF	137.13	137.27	137.12	137.16	3401406.0
2012-04-24 13:30:00	SPY	ETF	137.17	137.34	137.0	137.01	4834048.0
2012-04-24 14:00:00	SPY	ETF	137.01	137.07	136.85	136.98	7415362.0
2012-04-24 14:30:00	SPY	ETF	136.97	137.26	136.95	137.205	8319725.0
2012-04-24 15:00:00	SPY	ETF	137.21	137.3	137.06	137.15	6280290.0
2012-04-24 15:30:00	SPY	ETF	137.16	137.36	137.13	137.33	16938161.0
2012-04-24 16:00:00	SPY	ETF	137.33	137.68	137.2399	137.47	3169906.0
2012-04-24 16:30:00	SPY	ETF	137.56	138.23	137.53	138.11	2923234.0
2012-04-24 17:00:00	SPY	ETF	138.06	138.15	137.27	138.01	242318.0
2012-04-24 17:30:00	SPY	ETF	138.0	138.04	137.95	138.04	34335.0
2012-04-24 18:00:00	SPY	ETF	138.01	138.11	138.01	138.11	52575.0
2012-04-24 18:30:00	SPY	ETF	138.08	138.13	138.02	138.04	106405.0
2012-04-24 19:00:00	SPY	ETF	138.03	138.07	138.02	138.05	29827.0
2012-04-24 19:30:00	SPY	ETF	138.05	138.13	138.04	138.11	56067.0
2012-04-24 05:30:00	QQQ	ETF	65.48	65.48	65.48	65.48	400.0
2012-04-24 06:30:00	QQQ	ETF	65.42	65.44	65.42	65.44	1200.0
2012-04-24 07:00:00	QQQ	ETF	65.41	65.47	65.37	65.37	105890.0
2012-04-24 07:30:00	QQQ	ETF	65.37	65.42	65.29	65.29	384100.0
2012-04-24 08:00:00	QQQ	ETF	65.31	65.41	65.1	65.13	353156.0
2012-04-24 08:30:00	QQQ	ETF	65.12	65.12	64.93	64.94	652945.0
2012-04-24 09:00:00	QQQ	ETF	64.91	65.1	64.88	64.97	567493.0
2012-04-24 09:30:00	QQQ	ETF	64.97	65.08	64.79	64.89	7802164.0
2012-04-24 10:00:00	QQQ	ETF	64.88	65.23	64.86	65.08	6031339.0
2012-04-24 10:30:00	QQQ	ETF	65.08	65.13	64.91	64.9571	1999168.0
2012-04-24 11:00:00	QQQ	ETF	64.95	65.08	64.83	64.99	3421767.0
2012-04-24 11:30:00	QQQ	ETF	64.99	64.99	64.82	64.86	1332280.0
2012-04-24 12:00:00	QQQ	ETF	64.87	64.91	64.76	64.84	1296373.0
2012-04-24 12:30:00	QQQ	ETF	64.84	64.85	64.6	64.61	1771101.0
2012-04-24 13:00:00	QQQ	ETF	64.6108	64.69	64.6	64.6	1294986.0
2012-04-24 13:30:00	QQQ	ETF	64.605	64.71	64.475	64.4881	1937404.0
2012-04-24 14:00:00	QQQ	ETF	64.48	64.55	64.45	64.518	3196015.0
2012-04-24 14:30:00	QQQ	ETF	64.51	64.73	64.5091	64.7	2324452.0
2012-04-24 15:00:00	QQQ	ETF	64.7076	64.72	64.57	64.67	2455190.0

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

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