PREVIEW / etf_30min / 2011-05-16

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-05-16.parquet
  size:    289 KB
  rows:    9,534

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-05-16 04:00:00	SPY	ETF	133.72	133.72	133.51	133.51	8138.0
2011-05-16 04:30:00	SPY	ETF	133.44	133.44	133.43	133.43	200.0
2011-05-16 05:00:00	SPY	ETF	133.42	133.42	133.25	133.36	8100.0
2011-05-16 05:30:00	SPY	ETF	133.4	133.4	133.16	133.21	29500.0
2011-05-16 06:00:00	SPY	ETF	133.25	133.34	133.21	133.28	17325.0
2011-05-16 06:30:00	SPY	ETF	133.34	133.35	133.24	133.3	58625.0
2011-05-16 07:00:00	SPY	ETF	133.33	133.43	133.23	133.39	102413.0
2011-05-16 07:30:00	SPY	ETF	133.38	133.52	133.36	133.52	477870.0
2011-05-16 08:00:00	SPY	ETF	133.52	133.75	133.31	133.47	1435090.0
2011-05-16 08:30:00	SPY	ETF	133.46	134.04	133.38	133.46	815671.0
2011-05-16 09:00:00	SPY	ETF	133.46	133.75	133.44	133.56	1393180.0
2011-05-16 09:30:00	SPY	ETF	133.56	133.88	133.3	133.72	16510750.0
2011-05-16 10:00:00	SPY	ETF	133.72	134.21	133.685	134.09	11516593.0
2011-05-16 10:30:00	SPY	ETF	134.085	134.46	134.02	134.44	8420527.0
2011-05-16 11:00:00	SPY	ETF	134.44	134.61	134.32	134.38	8997901.0
2011-05-16 11:30:00	SPY	ETF	134.38	134.44	134.1	134.18	7557109.0
2011-05-16 12:00:00	SPY	ETF	134.185	134.22	133.93	134.01	6643522.0
2011-05-16 12:30:00	SPY	ETF	134.0	134.21	133.64	133.66	6676381.0
2011-05-16 13:00:00	SPY	ETF	133.67	133.71	133.46	133.66	6726897.0
2011-05-16 13:30:00	SPY	ETF	133.66	133.93	133.65	133.8	4449764.0
2011-05-16 14:00:00	SPY	ETF	133.8	134.015	133.54	133.56	6398096.0
2011-05-16 14:30:00	SPY	ETF	133.56	133.68	133.36	133.53	8580563.0
2011-05-16 15:00:00	SPY	ETF	133.53	133.81	133.37	133.39	8665758.0
2011-05-16 15:30:00	SPY	ETF	133.39	133.49	132.97	133.21	24740796.0
2011-05-16 16:00:00	SPY	ETF	133.21	133.7558	132.99	133.01	7641721.0
2011-05-16 16:30:00	SPY	ETF	133.01	133.05	132.5	132.74	819220.0
2011-05-16 17:00:00	SPY	ETF	132.74	132.78	132.64	132.64	240216.0
2011-05-16 17:30:00	SPY	ETF	132.64	132.7	132.63	132.69	57595.0
2011-05-16 18:00:00	SPY	ETF	132.72	133.19	132.7	132.77	149131.0
2011-05-16 18:30:00	SPY	ETF	132.79	132.79	132.73	132.74	7321.0
2011-05-16 19:00:00	SPY	ETF	132.79	132.81	132.7	132.7	11194.0
2011-05-16 19:30:00	SPY	ETF	132.7	132.74	132.65	132.72	38924.0
2011-05-16 05:30:00	QQQ	ETF	58.13	58.17	58.11	58.17	36500.0
2011-05-16 06:00:00	QQQ	ETF	58.2	58.21	58.2	58.21	20000.0
2011-05-16 07:00:00	QQQ	ETF	58.16	58.17	58.1	58.17	3700.0
2011-05-16 07:30:00	QQQ	ETF	58.15	58.2	58.12	58.18	24495.0
2011-05-16 08:00:00	QQQ	ETF	58.2	58.25	58.16	58.17	120235.0
2011-05-16 08:30:00	QQQ	ETF	58.17	58.2	58.14	58.17	229750.0
2011-05-16 09:00:00	QQQ	ETF	58.19	58.22	58.15	58.16	354839.0
2011-05-16 09:30:00	QQQ	ETF	58.16	58.269	58.0	58.17	5912403.0
2011-05-16 10:00:00	QQQ	ETF	58.16	58.29	58.12	58.15	5121491.0
2011-05-16 10:30:00	QQQ	ETF	58.16	58.24	58.13	58.2199	2486950.0
2011-05-16 11:00:00	QQQ	ETF	58.22	58.32	58.12	58.15	2924747.0
2011-05-16 11:30:00	QQQ	ETF	58.16	58.2	57.96	57.975	3458581.0
2011-05-16 12:00:00	QQQ	ETF	57.975	57.99	57.79	57.84	3926813.0
2011-05-16 12:30:00	QQQ	ETF	57.845	57.94	57.645	57.66	3224201.0
2011-05-16 13:00:00	QQQ	ETF	57.66	57.669	57.53	57.65	2658752.0
2011-05-16 13:30:00	QQQ	ETF	57.65	57.76	57.635	57.6805	1887561.0
2011-05-16 14:00:00	QQQ	ETF	57.68	57.8	57.55	57.56	1419110.0
2011-05-16 14:30:00	QQQ	ETF	57.56	57.63	57.45	57.521	3478274.0

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

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