PREVIEW / etf_1hour / 2010-05-06

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-06.parquet
  size:    183 KB
  rows:    5,691

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
2010-05-06 04:00:00	SPY	ETF	116.86	117.2	116.86	117.15	1200.0
2010-05-06 05:00:00	SPY	ETF	117.23	117.23	117.0	117.08	11100.0
2010-05-06 06:00:00	SPY	ETF	117.2	117.35	117.2	117.3	55050.0
2010-05-06 07:00:00	SPY	ETF	117.33	117.33	116.75	116.79	965733.0
2010-05-06 08:00:00	SPY	ETF	116.8	117.32	116.06	116.12	8998857.0
2010-05-06 09:00:00	SPY	ETF	116.11	116.94	116.02	116.66	41472603.0
2010-05-06 10:00:00	SPY	ETF	116.66	117.0	115.82	116.04	56451364.0
2010-05-06 11:00:00	SPY	ETF	116.01	116.15	115.22	115.68	66496766.0
2010-05-06 12:00:00	SPY	ETF	115.69	116.2	115.34	115.7	38515957.0
2010-05-06 13:00:00	SPY	ETF	115.7	115.84	114.58	114.7026	54487651.0
2010-05-06 14:00:00	SPY	ETF	114.7	114.85	105.0	111.79	178250950.0
2010-05-06 15:00:00	SPY	ETF	111.8	114.11	110.92	112.88	139510255.0
2010-05-06 16:00:00	SPY	ETF	112.88	116.84	109.65	112.13	37069146.0
2010-05-06 17:00:00	SPY	ETF	112.14	116.8061	112.11	112.23	6697759.0
2010-05-06 18:00:00	SPY	ETF	112.18	113.0316	112.04	112.18	10895934.0
2010-05-06 19:00:00	SPY	ETF	112.17	112.51	111.87	112.46	315224.0
2010-05-06 20:00:00	SPY	ETF	112.38	112.38	112.38	112.38	100.0
2010-05-06 04:00:00	QQQ	ETF	48.22	48.22	48.22	48.22	200.0
2010-05-06 05:00:00	QQQ	ETF	48.2	48.2	48.2	48.2	200.0
2010-05-06 06:00:00	QQQ	ETF	48.3	48.33	48.27	48.33	50630.0
2010-05-06 07:00:00	QQQ	ETF	48.32	48.33	48.11	48.14	148198.0
2010-05-06 08:00:00	QQQ	ETF	48.16	48.308	47.77	47.78	1928219.0
2010-05-06 09:00:00	QQQ	ETF	47.8	48.24	47.75	48.18	16899047.0
2010-05-06 10:00:00	QQQ	ETF	48.18	48.3201	47.81	47.89	17889048.0
2010-05-06 11:00:00	QQQ	ETF	47.89	47.89	47.58	47.82	29652238.0
2010-05-06 12:00:00	QQQ	ETF	47.82	48.02	47.61	47.77	19163629.0
2010-05-06 13:00:00	QQQ	ETF	47.77	47.82	47.32	47.42	23347943.0
2010-05-06 14:00:00	QQQ	ETF	47.42	47.48	41.55	46.16	86568442.0
2010-05-06 15:00:00	QQQ	ETF	46.16	47.08	44.01	46.58	53456542.0
2010-05-06 16:00:00	QQQ	ETF	46.57	48.25	45.99	46.25	8251623.0
2010-05-06 17:00:00	QQQ	ETF	46.24	46.44	46.2	46.3	290000.0
2010-05-06 18:00:00	QQQ	ETF	46.28	46.38	46.18	46.19	119324.0
2010-05-06 19:00:00	QQQ	ETF	46.21	46.34	46.1	46.31	145821.0
2010-05-06 04:00:00	IWM	ETF	70.2	70.2	70.2	70.2	100.0
2010-05-06 06:00:00	IWM	ETF	70.31	70.38	70.31	70.38	5300.0
2010-05-06 07:00:00	IWM	ETF	70.35	70.36	69.88	69.89	580207.0
2010-05-06 08:00:00	IWM	ETF	69.88	70.45	69.22	69.25	1802298.0
2010-05-06 09:00:00	IWM	ETF	69.26	70.14	69.21	70.12	14610464.0
2010-05-06 10:00:00	IWM	ETF	70.12	70.19	69.17	69.28	18078312.0
2010-05-06 11:00:00	IWM	ETF	69.29	69.31	68.59	68.86	18474900.0
2010-05-06 12:00:00	IWM	ETF	68.87	69.29	68.66	68.88	11961902.0
2010-05-06 13:00:00	IWM	ETF	68.87	68.94	67.92	67.95	14528705.0
2010-05-06 14:00:00	IWM	ETF	67.95	68.5	63.36	66.89	57891903.0
2010-05-06 15:00:00	IWM	ETF	66.89	69.9	65.375	67.29	43019261.0
2010-05-06 16:00:00	IWM	ETF	67.29	69.1	65.01	66.68	6747784.0
2010-05-06 17:00:00	IWM	ETF	66.73	67.14	66.54	66.85	142413.0
2010-05-06 18:00:00	IWM	ETF	67.0	67.0	66.56	66.6	3837.0
2010-05-06 19:00:00	IWM	ETF	66.7	66.79	66.38	66.79	6622.0
2010-05-06 20:00:00	IWM	ETF	66.65	66.65	66.65	66.65	200.0
2010-05-06 07:00:00	DIA	ETF	109.1	109.1	108.8	108.8	1300.0

> showing 50 of 5,691 rows — these rows as CSV

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