PREVIEW / etf_1hour / 2009-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-12-08.parquet
  size:    147 KB
  rows:    4,585

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-08 04:00:00	SPY	ETF	111.16	111.16	111.16	111.16	1000.0
2009-12-08 05:00:00	SPY	ETF	111.12	111.18	111.0	111.0	633.0
2009-12-08 06:00:00	SPY	ETF	111.0	111.0	110.18	110.38	50118.0
2009-12-08 07:00:00	SPY	ETF	110.31	110.31	109.8	110.06	1202629.0
2009-12-08 08:00:00	SPY	ETF	110.04	110.15	109.68	109.9	4455176.0
2009-12-08 09:00:00	SPY	ETF	109.9	110.13	109.27	109.695	29099671.0
2009-12-08 10:00:00	SPY	ETF	109.73	109.98	109.48	109.7	25976791.0
2009-12-08 11:00:00	SPY	ETF	109.69	110.25	109.65	110.0	22443012.0
2009-12-08 12:00:00	SPY	ETF	110.0	110.06	109.76	110.0	10695466.0
2009-12-08 13:00:00	SPY	ETF	109.99	110.08	109.6	109.8	12032340.0
2009-12-08 14:00:00	SPY	ETF	109.8	109.9	109.39	109.465	16964753.0
2009-12-08 15:00:00	SPY	ETF	109.46	109.78	109.44	109.64	28051962.0
2009-12-08 16:00:00	SPY	ETF	109.64	110.7725	109.42	109.47	16452487.0
2009-12-08 17:00:00	SPY	ETF	109.48	109.51	109.45	109.45	156904.0
2009-12-08 18:00:00	SPY	ETF	109.46	109.51	109.38	109.51	51806.0
2009-12-08 19:00:00	SPY	ETF	109.51	109.77	109.51	109.76	96225.0
2009-12-08 06:00:00	QQQ	ETF	43.88	43.88	43.63	43.69	30166.0
2009-12-08 07:00:00	QQQ	ETF	43.67	43.67	43.46	43.57	636031.0
2009-12-08 08:00:00	QQQ	ETF	43.56	43.66	43.46	43.55	1411558.0
2009-12-08 09:00:00	QQQ	ETF	43.54	43.69	43.36	43.54	17800002.0
2009-12-08 10:00:00	QQQ	ETF	43.54	43.69	43.47	43.57	13944298.0
2009-12-08 11:00:00	QQQ	ETF	43.57	44.0	43.55	43.91	13868807.0
2009-12-08 12:00:00	QQQ	ETF	43.92	43.96	43.8	43.9	5104818.0
2009-12-08 13:00:00	QQQ	ETF	43.89	43.91	43.74	43.83	6430083.0
2009-12-08 14:00:00	QQQ	ETF	43.83	43.8601	43.62	43.6425	7913620.0
2009-12-08 15:00:00	QQQ	ETF	43.65	43.76	43.62	43.64	9817864.0
2009-12-08 16:00:00	QQQ	ETF	43.64	43.9292	43.4849	43.57	6506084.0
2009-12-08 17:00:00	QQQ	ETF	43.57	43.58	43.53	43.56	31964.0
2009-12-08 18:00:00	QQQ	ETF	43.56	43.57	43.52	43.56	26300.0
2009-12-08 19:00:00	QQQ	ETF	43.58	43.67	43.58	43.66	57363.0
2009-12-08 06:00:00	IWM	ETF	60.39	60.39	60.04	60.19	25900.0
2009-12-08 07:00:00	IWM	ETF	60.05	60.17	59.85	59.95	47880.0
2009-12-08 08:00:00	IWM	ETF	59.97	60.23	59.8	59.9	651624.0
2009-12-08 09:00:00	IWM	ETF	59.89	60.21	59.38	59.9	14318386.0
2009-12-08 10:00:00	IWM	ETF	59.91	60.28	59.76	60.09	10370658.0
2009-12-08 11:00:00	IWM	ETF	60.09	60.47	60.06	60.33	7220340.0
2009-12-08 12:00:00	IWM	ETF	60.33	60.36	60.115	60.31	3203914.0
2009-12-08 13:00:00	IWM	ETF	60.31	60.38	60.02	60.08	3653988.0
2009-12-08 14:00:00	IWM	ETF	60.08	60.14	59.86	59.89	5366596.0
2009-12-08 15:00:00	IWM	ETF	59.9	60.11	59.86	59.99	9785077.0
2009-12-08 16:00:00	IWM	ETF	60.0	60.393	59.82	59.89	1521139.0
2009-12-08 17:00:00	IWM	ETF	59.93	59.93	59.91	59.93	11600.0
2009-12-08 19:00:00	IWM	ETF	59.9	60.02	59.85	60.02	6300.0
2009-12-08 06:00:00	DIA	ETF	103.63	103.63	103.62	103.62	500.0
2009-12-08 07:00:00	DIA	ETF	103.51	103.61	103.39	103.5	4700.0
2009-12-08 08:00:00	DIA	ETF	103.5	103.5	103.02	103.3	49200.0
2009-12-08 09:00:00	DIA	ETF	103.25	103.47	102.61	102.98	2121846.0
2009-12-08 10:00:00	DIA	ETF	102.98	103.21	102.82	102.99	1965041.0
2009-12-08 11:00:00	DIA	ETF	102.9999	103.44	102.5	103.2	1377842.0
2009-12-08 12:00:00	DIA	ETF	103.2	103.25	103.0	103.175	670034.0

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

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