PREVIEW / etf_1hour / 2009-11-12

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-12.parquet
  size:    144 KB
  rows:    4,455

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-11-12 04:00:00	SPY	ETF	109.57	109.6	109.45	109.57	4255.0
2009-11-12 05:00:00	SPY	ETF	109.78	109.88	109.78	109.88	3600.0
2009-11-12 06:00:00	SPY	ETF	109.79	109.79	109.65	109.65	3000.0
2009-11-12 07:00:00	SPY	ETF	109.74	109.92	109.47	109.67	743318.0
2009-11-12 08:00:00	SPY	ETF	109.67	110.15	109.38	109.84	3576471.0
2009-11-12 09:00:00	SPY	ETF	109.84	110.55	109.65	110.4	22250086.0
2009-11-12 10:00:00	SPY	ETF	110.4	110.57	109.9	110.0401	24218421.0
2009-11-12 11:00:00	SPY	ETF	110.04	110.06	109.33	109.49	28447039.0
2009-11-12 12:00:00	SPY	ETF	109.48	109.73	109.34	109.49	12295844.0
2009-11-12 13:00:00	SPY	ETF	109.49	109.55	109.18	109.42	14470622.0
2009-11-12 14:00:00	SPY	ETF	109.42	109.58	109.09	109.15	11300105.0
2009-11-12 15:00:00	SPY	ETF	109.14	109.21	108.75	109.011	30939711.0
2009-11-12 16:00:00	SPY	ETF	109.02	110.24	108.95	109.16	7769947.0
2009-11-12 17:00:00	SPY	ETF	109.16	109.16	109.1	109.14	110972.0
2009-11-12 18:00:00	SPY	ETF	109.14	109.21	109.11	109.21	26625.0
2009-11-12 19:00:00	SPY	ETF	109.16	109.22	109.04	109.07	61758.0
2009-11-12 04:00:00	QQQ	ETF	43.69	43.69	43.69	43.69	100.0
2009-11-12 05:00:00	QQQ	ETF	43.74	43.8	43.74	43.79	4200.0
2009-11-12 06:00:00	QQQ	ETF	43.82	43.82	43.75	43.75	600.0
2009-11-12 07:00:00	QQQ	ETF	43.81	43.81	43.65	43.71	207237.0
2009-11-12 08:00:00	QQQ	ETF	43.71	43.86	43.61	43.81	1040787.0
2009-11-12 09:00:00	QQQ	ETF	43.82	44.15	43.81	44.1	15861917.0
2009-11-12 10:00:00	QQQ	ETF	44.11	44.16	43.88	43.95	16556858.0
2009-11-12 11:00:00	QQQ	ETF	43.94	43.98	43.73	43.79	14850800.0
2009-11-12 12:00:00	QQQ	ETF	43.7897	43.91	43.75	43.82	7810850.0
2009-11-12 13:00:00	QQQ	ETF	43.81	43.83	43.7	43.79	7470656.0
2009-11-12 14:00:00	QQQ	ETF	43.79	43.84	43.66	43.685	6893524.0
2009-11-12 15:00:00	QQQ	ETF	43.69	43.72	43.55	43.64	14819882.0
2009-11-12 16:00:00	QQQ	ETF	43.64	43.69	43.62	43.65	2307200.0
2009-11-12 17:00:00	QQQ	ETF	43.65	43.66	43.64	43.64	85029.0
2009-11-12 18:00:00	QQQ	ETF	43.64	43.68	43.64	43.68	14040.0
2009-11-12 19:00:00	QQQ	ETF	43.66	43.66	43.6	43.62	19850.0
2009-11-12 07:00:00	IWM	ETF	58.98	58.98	58.85	58.95	9700.0
2009-11-12 08:00:00	IWM	ETF	58.97	59.26	58.72	59.11	573876.0
2009-11-12 09:00:00	IWM	ETF	59.12	59.64	58.88	59.55	8743809.0
2009-11-12 10:00:00	IWM	ETF	59.56	59.73	59.23	59.5	8017312.0
2009-11-12 11:00:00	IWM	ETF	59.5	59.5	58.54	58.66	11758214.0
2009-11-12 12:00:00	IWM	ETF	58.6599	58.83	58.63	58.7	4810890.0
2009-11-12 13:00:00	IWM	ETF	58.7	58.75	58.51	58.63	4578160.0
2009-11-12 14:00:00	IWM	ETF	58.62	58.69	58.25	58.28	7563138.0
2009-11-12 15:00:00	IWM	ETF	58.28	58.35	58.0	58.12	12416177.0
2009-11-12 16:00:00	IWM	ETF	58.13	59.3399	58.07	58.19	7696241.0
2009-11-12 17:00:00	IWM	ETF	58.21	58.22	58.16	58.17	12600.0
2009-11-12 18:00:00	IWM	ETF	58.24	58.26	58.18	58.18	1600.0
2009-11-12 19:00:00	IWM	ETF	58.2	58.2	58.2	58.2	300.0
2009-11-12 06:00:00	DIA	ETF	102.85	102.85	102.82	102.82	300.0
2009-11-12 07:00:00	DIA	ETF	102.63	102.63	102.63	102.63	100.0
2009-11-12 08:00:00	DIA	ETF	102.78	102.99	102.77	102.83	19300.0
2009-11-12 09:00:00	DIA	ETF	102.92	103.37	102.79	103.29	2017958.0
2009-11-12 10:00:00	DIA	ETF	103.28	103.41	102.9	102.98	2091946.0

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

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