PREVIEW / etf_1hour / 2010-05-03

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-05-03.parquet
  size:    162 KB
  rows:    4,919

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-03 04:00:00	SPY	ETF	119.2	119.31	119.2	119.26	650.0
2010-05-03 05:00:00	SPY	ETF	119.18	119.18	119.02	119.02	3800.0
2010-05-03 06:00:00	SPY	ETF	119.11	119.28	119.1	119.28	85500.0
2010-05-03 07:00:00	SPY	ETF	119.3	119.46	119.3	119.34	1085015.0
2010-05-03 08:00:00	SPY	ETF	119.18	119.49	118.8125	119.34	921282.0
2010-05-03 09:00:00	SPY	ETF	119.34	119.72	118.8125	119.6583	20016633.0
2010-05-03 10:00:00	SPY	ETF	119.65	119.82	119.2	119.34	29680244.0
2010-05-03 11:00:00	SPY	ETF	119.34	119.86	119.28	119.7784	15636508.0
2010-05-03 12:00:00	SPY	ETF	119.779	120.55	119.6	120.55	27132432.0
2010-05-03 13:00:00	SPY	ETF	120.545	120.66	120.3	120.52	20475464.0
2010-05-03 14:00:00	SPY	ETF	120.53	120.68	120.38	120.6099	16918954.0
2010-05-03 15:00:00	SPY	ETF	120.61	120.67	120.18	120.39	39157553.0
2010-05-03 16:00:00	SPY	ETF	120.39	120.44	119.29	120.24	10822464.0
2010-05-03 17:00:00	SPY	ETF	120.24	120.36	120.18	120.24	160844.0
2010-05-03 18:00:00	SPY	ETF	120.23	120.31	120.23	120.31	46473.0
2010-05-03 19:00:00	SPY	ETF	120.32	120.34	120.25	120.25	37748.0
2010-05-03 04:00:00	QQQ	ETF	49.33	49.33	49.33	49.33	414.0
2010-05-03 05:00:00	QQQ	ETF	49.28	49.28	49.28	49.28	2000.0
2010-05-03 06:00:00	QQQ	ETF	49.41	49.41	49.41	49.41	1000.0
2010-05-03 07:00:00	QQQ	ETF	49.44	49.48	49.4	49.4	192461.0
2010-05-03 08:00:00	QQQ	ETF	49.4	49.45	49.38	49.42	610736.0
2010-05-03 09:00:00	QQQ	ETF	49.42	49.6	49.2375	49.55	7381855.0
2010-05-03 10:00:00	QQQ	ETF	49.56	49.76	49.47	49.63	11249072.0
2010-05-03 11:00:00	QQQ	ETF	49.629	49.9	49.57	49.86	7769429.0
2010-05-03 12:00:00	QQQ	ETF	49.87	50.17	49.83	50.165	10651009.0
2010-05-03 13:00:00	QQQ	ETF	50.1699	50.17	50.05	50.12	7156006.0
2010-05-03 14:00:00	QQQ	ETF	50.13	50.13	50.02	50.08	8554326.0
2010-05-03 15:00:00	QQQ	ETF	50.08	50.1411	49.9	49.93	12656886.0
2010-05-03 16:00:00	QQQ	ETF	49.93	50.1411	49.65	49.87	3373579.0
2010-05-03 17:00:00	QQQ	ETF	49.86	49.87	49.85	49.85	17900.0
2010-05-03 18:00:00	QQQ	ETF	49.87	49.88	49.87	49.87	4000.0
2010-05-03 19:00:00	QQQ	ETF	49.91	49.91	49.87	49.87	10100.0
2010-05-03 06:00:00	IWM	ETF	72.07	72.07	72.05	72.05	2500.0
2010-05-03 07:00:00	IWM	ETF	72.13	72.14	72.01	72.07	22003.0
2010-05-03 08:00:00	IWM	ETF	72.07	72.13	71.65	72.04	162874.0
2010-05-03 09:00:00	IWM	ETF	72.06	72.39	72.0	72.25	6929249.0
2010-05-03 10:00:00	IWM	ETF	72.23	72.71	72.06	72.2	10183041.0
2010-05-03 11:00:00	IWM	ETF	72.2	72.7	72.17	72.62	4436479.0
2010-05-03 12:00:00	IWM	ETF	72.62	73.0901	72.53	73.08	6628392.0
2010-05-03 13:00:00	IWM	ETF	73.08	73.18	72.89	73.12	4775244.0
2010-05-03 14:00:00	IWM	ETF	73.12	73.27	72.985	73.15	5424493.0
2010-05-03 15:00:00	IWM	ETF	73.15	73.31	72.82	73.27	12444835.0
2010-05-03 16:00:00	IWM	ETF	73.27	73.29	71.6793	73.08	2583081.0
2010-05-03 17:00:00	IWM	ETF	73.1	73.14	73.1	73.1	44826.0
2010-05-03 18:00:00	IWM	ETF	73.15	73.15	73.15	73.15	490.0
2010-05-03 19:00:00	IWM	ETF	73.16	73.19	73.14	73.15	1000.0
2010-05-03 07:00:00	DIA	ETF	110.51	110.53	110.47	110.48	21953.0
2010-05-03 08:00:00	DIA	ETF	110.51	110.55	110.47	110.48	20578.0
2010-05-03 09:00:00	DIA	ETF	110.45	110.99	110.43	110.98	1065642.0
2010-05-03 10:00:00	DIA	ETF	110.98	111.13	110.62	110.7101	1340168.0

> showing 50 of 4,919 rows — these rows as CSV

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