PREVIEW / etf_1hour / 2009-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-10-14.parquet
  size:    149 KB
  rows:    4,577

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-10-14 04:00:00	SPY	ETF	108.37	108.58	108.3	108.58	3150.0
2009-10-14 05:00:00	SPY	ETF	108.59	108.77	108.59	108.74	21100.0
2009-10-14 06:00:00	SPY	ETF	108.7	109.0	108.63	108.95	114693.0
2009-10-14 07:00:00	SPY	ETF	108.93	108.96	108.73	108.76	1078508.0
2009-10-14 08:00:00	SPY	ETF	108.76	108.9	107.5	108.83	3289790.0
2009-10-14 09:00:00	SPY	ETF	108.84	108.84	108.35	108.56	26297551.0
2009-10-14 10:00:00	SPY	ETF	108.56	108.67	108.26	108.58	28005457.0
2009-10-14 11:00:00	SPY	ETF	108.59	108.84	108.5	108.76	16317188.0
2009-10-14 12:00:00	SPY	ETF	108.76	108.8	108.62	108.8	12509546.0
2009-10-14 13:00:00	SPY	ETF	108.8	108.98	108.77	108.89	16826560.0
2009-10-14 14:00:00	SPY	ETF	108.89	109.0	108.5	108.88	20249920.0
2009-10-14 15:00:00	SPY	ETF	108.88	109.42	108.87	109.3207	47551216.0
2009-10-14 16:00:00	SPY	ETF	109.32	109.36	108.42	109.32	16039511.0
2009-10-14 17:00:00	SPY	ETF	109.32	109.32	109.21	109.22	1220895.0
2009-10-14 18:00:00	SPY	ETF	109.21	109.34	109.18	109.31	35025.0
2009-10-14 19:00:00	SPY	ETF	109.31	109.36	109.3	109.35	44652.0
2009-10-14 04:00:00	QQQ	ETF	43.0	43.06	43.0	43.06	2200.0
2009-10-14 05:00:00	QQQ	ETF	43.1	43.1	43.08	43.08	5100.0
2009-10-14 06:00:00	QQQ	ETF	43.07	43.18	43.07	43.18	31500.0
2009-10-14 07:00:00	QQQ	ETF	43.14	43.17	43.07	43.14	278003.0
2009-10-14 08:00:00	QQQ	ETF	43.13	43.15	43.06	43.14	1135869.0
2009-10-14 09:00:00	QQQ	ETF	43.14	43.16	42.85	42.95	19222556.0
2009-10-14 10:00:00	QQQ	ETF	42.94	43.02	42.8704	42.95	14501790.0
2009-10-14 11:00:00	QQQ	ETF	42.9569	43.293	42.9282	43.03	7287052.0
2009-10-14 12:00:00	QQQ	ETF	43.02	43.05	42.95	43.05	7922564.0
2009-10-14 13:00:00	QQQ	ETF	43.0426	43.09	42.99	43.02	7213540.0
2009-10-14 14:00:00	QQQ	ETF	43.012	43.08	42.95	43.01	8674039.0
2009-10-14 15:00:00	QQQ	ETF	43.01	43.21	43.0	43.16	18413944.0
2009-10-14 16:00:00	QQQ	ETF	43.158	43.17	43.0266	43.08	4274972.0
2009-10-14 17:00:00	QQQ	ETF	43.08	43.09	43.05	43.07	87911.0
2009-10-14 18:00:00	QQQ	ETF	43.06	43.16	43.04	43.05	168138.0
2009-10-14 19:00:00	QQQ	ETF	43.06	43.09	43.05	43.07	58487.0
2009-10-14 06:00:00	IWM	ETF	62.07	62.22	62.07	62.22	4200.0
2009-10-14 07:00:00	IWM	ETF	62.17	62.18	62.07	62.13	72439.0
2009-10-14 08:00:00	IWM	ETF	62.12	62.18	61.88	62.1	206471.0
2009-10-14 09:00:00	IWM	ETF	62.1	62.16	61.64	61.82	6550244.0
2009-10-14 10:00:00	IWM	ETF	61.82	61.9	61.55	61.85	5737182.0
2009-10-14 11:00:00	IWM	ETF	61.86	62.07	61.84	61.94	3723518.0
2009-10-14 12:00:00	IWM	ETF	61.95	62.08	61.92	62.08	3431708.0
2009-10-14 13:00:00	IWM	ETF	62.08	62.25	62.04	62.09	3340222.0
2009-10-14 14:00:00	IWM	ETF	62.1	62.19	61.96	62.1	4161248.0
2009-10-14 15:00:00	IWM	ETF	62.1	62.46	62.09	62.37	9439803.0
2009-10-14 16:00:00	IWM	ETF	62.37	62.4187	62.0279	62.21	1235409.0
2009-10-14 17:00:00	IWM	ETF	62.21	62.24	62.17	62.21	18694.0
2009-10-14 19:00:00	IWM	ETF	62.29	62.29	62.28	62.28	1800.0
2009-10-14 04:00:00	DIA	ETF	99.41	99.58	99.41	99.58	700.0
2009-10-14 05:00:00	DIA	ETF	99.6	99.6	99.6	99.6	100.0
2009-10-14 07:00:00	DIA	ETF	99.95	99.97	99.85	99.9	10175.0
2009-10-14 08:00:00	DIA	ETF	99.82	99.88	99.59	99.79	64821.0
2009-10-14 09:00:00	DIA	ETF	99.8	99.85	99.51	99.73	1390409.0

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

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