PREVIEW / etf_1hour / 2009-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-09.parquet
  size:    145 KB
  rows:    4,492

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
2009-12-09 04:00:00	SPY	ETF	109.63	109.74	109.63	109.7	2100.0
2009-12-09 05:00:00	SPY	ETF	109.66	110.01	109.66	110.01	3050.0
2009-12-09 06:00:00	SPY	ETF	109.97	110.11	109.9	110.11	6600.0
2009-12-09 07:00:00	SPY	ETF	110.21	110.21	109.97	110.02	109830.0
2009-12-09 08:00:00	SPY	ETF	110.03	110.12	109.68	109.88	2277090.0
2009-12-09 09:00:00	SPY	ETF	109.87	109.8953	109.02	109.4099	27735753.0
2009-12-09 10:00:00	SPY	ETF	109.41	110.01	109.16	109.75	26870077.0
2009-12-09 11:00:00	SPY	ETF	109.75	109.89	109.52	109.68	13631360.0
2009-12-09 12:00:00	SPY	ETF	109.67	109.68	109.3	109.5	13361891.0
2009-12-09 13:00:00	SPY	ETF	109.4925	109.5	109.11	109.22	14159130.0
2009-12-09 14:00:00	SPY	ETF	109.22	109.73	109.18	109.63	12614110.0
2009-12-09 15:00:00	SPY	ETF	109.63	110.18	109.625	110.01	27394592.0
2009-12-09 16:00:00	SPY	ETF	110.0	110.1459	109.0961	110.11	9857976.0
2009-12-09 17:00:00	SPY	ETF	110.12	110.19	109.61	110.17	597645.0
2009-12-09 18:00:00	SPY	ETF	110.18	110.24	110.14	110.18	58046.0
2009-12-09 19:00:00	SPY	ETF	110.22	110.39	110.16	110.35	43650.0
2009-12-09 04:00:00	QQQ	ETF	43.6	43.6	43.6	43.6	500.0
2009-12-09 05:00:00	QQQ	ETF	43.6	43.75	43.6	43.75	900.0
2009-12-09 06:00:00	QQQ	ETF	43.73	43.82	43.73	43.82	6700.0
2009-12-09 07:00:00	QQQ	ETF	43.85	43.86	43.75	43.77	47006.0
2009-12-09 08:00:00	QQQ	ETF	43.78	43.82	43.69	43.73	495230.0
2009-12-09 09:00:00	QQQ	ETF	43.7	43.7	43.32	43.525	11403989.0
2009-12-09 10:00:00	QQQ	ETF	43.52	43.85	43.45	43.75	14681735.0
2009-12-09 11:00:00	QQQ	ETF	43.76	43.81	43.68	43.75	5738536.0
2009-12-09 12:00:00	QQQ	ETF	43.75	43.7501	43.6	43.7	7131012.0
2009-12-09 13:00:00	QQQ	ETF	43.71	43.72	43.58	43.63	6199148.0
2009-12-09 14:00:00	QQQ	ETF	43.63	43.87	43.615	43.83	7292686.0
2009-12-09 15:00:00	QQQ	ETF	43.84	44.12	43.835	44.08	17378732.0
2009-12-09 16:00:00	QQQ	ETF	44.07	44.17	43.6637	44.16	6557283.0
2009-12-09 17:00:00	QQQ	ETF	44.17	44.2	44.08	44.18	55269.0
2009-12-09 18:00:00	QQQ	ETF	44.18	44.21	44.18	44.2	60974.0
2009-12-09 19:00:00	QQQ	ETF	44.19	44.27	44.18	44.26	52775.0
2009-12-09 06:00:00	IWM	ETF	60.13	60.3	60.13	60.28	800.0
2009-12-09 08:00:00	IWM	ETF	60.31	60.32	60.12	60.13	402160.0
2009-12-09 09:00:00	IWM	ETF	60.13	60.13	59.3	59.58	10152468.0
2009-12-09 10:00:00	IWM	ETF	59.57	60.0	59.35	59.82	9720792.0
2009-12-09 11:00:00	IWM	ETF	59.82	59.89	59.54	59.64	3728916.0
2009-12-09 12:00:00	IWM	ETF	59.6399	59.68	59.41	59.5399	2988812.0
2009-12-09 13:00:00	IWM	ETF	59.54	59.54	59.34	59.39	4999116.0
2009-12-09 14:00:00	IWM	ETF	59.39	59.71	59.34	59.659	5011475.0
2009-12-09 15:00:00	IWM	ETF	59.66	60.07	59.655	59.9	10509973.0
2009-12-09 16:00:00	IWM	ETF	59.9	60.0102	59.5	59.92	3834532.0
2009-12-09 17:00:00	IWM	ETF	59.94	59.99	59.93	59.98	6458.0
2009-12-09 18:00:00	IWM	ETF	59.98	59.99	59.93	59.99	3281.0
2009-12-09 19:00:00	IWM	ETF	59.99	60.0	59.99	60.0	432.0
2009-12-09 07:00:00	DIA	ETF	103.3	103.3	103.3	103.3	100.0
2009-12-09 08:00:00	DIA	ETF	103.5	103.5	103.15	103.22	214940.0
2009-12-09 09:00:00	DIA	ETF	103.18	103.2	102.48	102.88	1547990.0
2009-12-09 10:00:00	DIA	ETF	102.88	103.44	102.7	103.22	1349101.0
2009-12-09 11:00:00	DIA	ETF	103.22	103.37	103.03	103.16	874323.0

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

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