PREVIEW / etf_1hour / 2008-03-19

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-19.parquet
  size:    105 KB
  rows:    3,457

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
2008-03-19 04:00:00	SPY	ETF	132.65	132.7	132.44	132.7	6500.0
2008-03-19 05:00:00	SPY	ETF	132.61	132.9	132.61	132.7	900.0
2008-03-19 06:00:00	SPY	ETF	132.65	132.96	132.56	132.8	73900.0
2008-03-19 07:00:00	SPY	ETF	132.76	133.44	132.4	133.06	2627100.0
2008-03-19 08:00:00	SPY	ETF	133.06	133.67	132.88	133.6	6579360.0
2008-03-19 09:00:00	SPY	ETF	133.61	134.65	133.59	133.76	44104365.0
2008-03-19 10:00:00	SPY	ETF	133.76	134.21	133.01	133.46	53700989.0
2008-03-19 11:00:00	SPY	ETF	133.46	134.19	133.35	133.77	22832908.0
2008-03-19 12:00:00	SPY	ETF	133.78	134.08	132.0	132.78	38642653.0
2008-03-19 13:00:00	SPY	ETF	132.79	134.35	131.58	131.95	45808012.0
2008-03-19 14:00:00	SPY	ETF	131.95	134.48	131.02	131.99	52320388.0
2008-03-19 15:00:00	SPY	ETF	131.99	132.41	130.24	130.36	62239049.0
2008-03-19 16:00:00	SPY	ETF	130.28	133.4	130.0	130.07	9636700.0
2008-03-19 17:00:00	SPY	ETF	130.07	133.5106	130.07	130.22	2242900.0
2008-03-19 18:00:00	SPY	ETF	130.13	130.589	129.9	129.92	314300.0
2008-03-19 19:00:00	SPY	ETF	129.9	130.09	129.65	129.76	111500.0
2008-03-19 20:00:00	SPY	ETF	129.76	129.76	129.76	129.76	800.0
2008-03-19 04:00:00	QQQ	ETF	43.3	43.3	43.3	43.3	1600.0
2008-03-19 05:00:00	QQQ	ETF	43.08	43.08	43.08	43.08	100.0
2008-03-19 06:00:00	QQQ	ETF	43.11	43.2	43.06	43.2	7238.0
2008-03-19 07:00:00	QQQ	ETF	43.2	43.3	43.08	43.19	282266.0
2008-03-19 08:00:00	QQQ	ETF	43.18	43.36	43.14	43.34	2220151.0
2008-03-19 09:00:00	QQQ	ETF	43.34	43.7	43.15	43.36	24410997.0
2008-03-19 10:00:00	QQQ	ETF	43.355	43.5	42.98	43.2199	37166764.0
2008-03-19 11:00:00	QQQ	ETF	43.22	43.55	43.17	43.35	23098010.0
2008-03-19 12:00:00	QQQ	ETF	43.3599	43.41	42.99	43.08	21023856.0
2008-03-19 13:00:00	QQQ	ETF	43.09	43.2	42.81	42.87	25947429.0
2008-03-19 14:00:00	QQQ	ETF	42.87	43.0	42.63	42.84	24839218.0
2008-03-19 15:00:00	QQQ	ETF	42.84	43.02	42.23	42.25	35242759.0
2008-03-19 16:00:00	QQQ	ETF	42.25	42.98	42.22	42.23	5226701.0
2008-03-19 17:00:00	QQQ	ETF	42.26	42.29	42.22	42.24	158687.0
2008-03-19 18:00:00	QQQ	ETF	42.25	42.25	42.18	42.19	32456.0
2008-03-19 19:00:00	QQQ	ETF	42.18	42.18	42.1	42.11	39378.0
2008-03-19 06:00:00	IWM	ETF	67.65	67.67	67.65	67.67	7400.0
2008-03-19 07:00:00	IWM	ETF	67.6	67.85	67.46	67.83	54400.0
2008-03-19 08:00:00	IWM	ETF	67.67	68.08	66.6	68.06	634600.0
2008-03-19 09:00:00	IWM	ETF	68.04	68.93	67.65	68.19	19528991.0
2008-03-19 10:00:00	IWM	ETF	68.19	68.59	67.85	68.23	19281878.0
2008-03-19 11:00:00	IWM	ETF	68.23	68.49	68.13	68.2	10803598.0
2008-03-19 12:00:00	IWM	ETF	68.19	68.28	67.38	67.65	14027511.0
2008-03-19 13:00:00	IWM	ETF	67.66	68.0	67.23	67.44	12526399.0
2008-03-19 14:00:00	IWM	ETF	67.43	67.57	66.83	67.31	18780111.0
2008-03-19 15:00:00	IWM	ETF	67.3	67.52	66.25	66.26	28033264.0
2008-03-19 16:00:00	IWM	ETF	66.28	67.7	66.11	66.17	3205300.0
2008-03-19 17:00:00	IWM	ETF	66.17	66.31	66.06	66.06	653500.0
2008-03-19 18:00:00	IWM	ETF	66.57	66.57	66.0	66.0	607500.0
2008-03-19 19:00:00	IWM	ETF	66.0	66.0	65.88	65.88	2800.0
2008-03-19 06:00:00	DIA	ETF	123.69	123.69	123.69	123.69	100.0
2008-03-19 07:00:00	DIA	ETF	123.4	123.84	123.4	123.84	7600.0
2008-03-19 08:00:00	DIA	ETF	123.71	124.05	123.52	124.05	58400.0

> showing 50 of 3,457 rows — these rows as CSV

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