PREVIEW / etf_1hour / 2008-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-30.parquet
  size:    101 KB
  rows:    3,415

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-01-30 04:00:00	SPY	ETF	135.4	135.4	135.36	135.36	1700.0
2008-01-30 05:00:00	SPY	ETF	135.51	135.54	135.5	135.54	50100.0
2008-01-30 06:00:00	SPY	ETF	135.78	135.93	135.78	135.82	42800.0
2008-01-30 07:00:00	SPY	ETF	135.73	135.76	135.34	135.48	363000.0
2008-01-30 08:00:00	SPY	ETF	135.5	136.2	135.16	135.58	6760400.0
2008-01-30 09:00:00	SPY	ETF	135.6	135.82	135.23	135.76	20508538.0
2008-01-30 10:00:00	SPY	ETF	135.76	136.19	135.73	136.06	21833903.0
2008-01-30 11:00:00	SPY	ETF	136.06	136.11	135.46	135.67	15212105.0
2008-01-30 12:00:00	SPY	ETF	135.65	135.87	135.56	135.73	8826692.0
2008-01-30 13:00:00	SPY	ETF	135.73	136.0	135.4868	135.67	12322787.0
2008-01-30 14:00:00	SPY	ETF	135.67	138.1	135.56	138.08	113820152.0
2008-01-30 15:00:00	SPY	ETF	138.08	138.54	135.05	135.36	111468301.0
2008-01-30 16:00:00	SPY	ETF	135.31	136.901	134.32	134.44	14893200.0
2008-01-30 17:00:00	SPY	ETF	134.45	134.45	133.35	133.49	2583200.0
2008-01-30 18:00:00	SPY	ETF	133.49	133.6	133.2	133.49	390400.0
2008-01-30 19:00:00	SPY	ETF	133.53	133.8	133.45	133.8	76200.0
2008-01-30 04:00:00	QQQ	ETF	44.13	44.13	44.13	44.13	2000.0
2008-01-30 05:00:00	QQQ	ETF	44.2	44.2	44.2	44.2	300.0
2008-01-30 06:00:00	QQQ	ETF	44.2	44.22	44.2	44.21	50500.0
2008-01-30 07:00:00	QQQ	ETF	44.21	44.23	44.15	44.17	379084.0
2008-01-30 08:00:00	QQQ	ETF	44.17	44.42	44.09	44.2	1666627.0
2008-01-30 09:00:00	QQQ	ETF	44.22	44.5	44.18	44.43	11448453.0
2008-01-30 10:00:00	QQQ	ETF	44.44	44.67	44.34	44.64	21618929.0
2008-01-30 11:00:00	QQQ	ETF	44.64	44.67	44.4	44.46	11580286.0
2008-01-30 12:00:00	QQQ	ETF	44.46	44.48	44.35	44.38	6436829.0
2008-01-30 13:00:00	QQQ	ETF	44.38	44.46	44.28	44.34	8970077.0
2008-01-30 14:00:00	QQQ	ETF	44.34	45.14	44.31	45.1198	77507626.0
2008-01-30 15:00:00	QQQ	ETF	45.11	45.32	44.39	44.43	68892925.0
2008-01-30 16:00:00	QQQ	ETF	44.41	44.86	44.14	44.17	10025737.0
2008-01-30 17:00:00	QQQ	ETF	44.17	44.17	43.69	43.75	1199006.0
2008-01-30 18:00:00	QQQ	ETF	43.75	43.82	43.72	43.8	964733.0
2008-01-30 19:00:00	QQQ	ETF	43.8	43.86	43.8	43.84	81288.0
2008-01-30 05:00:00	IWM	ETF	70.0	70.0	70.0	70.0	100.0
2008-01-30 06:00:00	IWM	ETF	70.06	70.06	70.0	70.0	5000.0
2008-01-30 07:00:00	IWM	ETF	69.99	70.0	69.75	69.77	213400.0
2008-01-30 08:00:00	IWM	ETF	69.73	70.3	69.64	69.66	1036200.0
2008-01-30 09:00:00	IWM	ETF	69.66	69.98	69.53	69.89	5011814.0
2008-01-30 10:00:00	IWM	ETF	69.9	70.39	69.77	70.17	7483867.0
2008-01-30 11:00:00	IWM	ETF	70.19	70.23	69.38	69.62	9264273.0
2008-01-30 12:00:00	IWM	ETF	69.62	69.69	69.52	69.62	3669893.0
2008-01-30 13:00:00	IWM	ETF	69.62	69.9	69.55	69.68	7264750.0
2008-01-30 14:00:00	IWM	ETF	69.68	71.2	69.6	70.95	47622214.0
2008-01-30 15:00:00	IWM	ETF	70.95	71.4	69.1	69.28	40323533.0
2008-01-30 16:00:00	IWM	ETF	69.28	70.22	68.57	68.63	4638900.0
2008-01-30 17:00:00	IWM	ETF	68.63	68.63	68.15	68.2	216700.0
2008-01-30 18:00:00	IWM	ETF	68.1	68.19	68.06	68.19	97500.0
2008-01-30 19:00:00	IWM	ETF	68.19	68.33	68.19	68.33	18700.0
2008-01-30 07:00:00	DIA	ETF	124.37	124.4	124.37	124.4	3000.0
2008-01-30 08:00:00	DIA	ETF	124.34	124.61	124.28	124.29	31400.0
2008-01-30 09:00:00	DIA	ETF	124.34	124.36	123.96	124.24	1233230.0

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

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