PREVIEW / etf_1hour / 2009-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-03-26.parquet
  size:    132 KB
  rows:    4,083

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-03-26 04:00:00	SPY	ETF	82.15	82.18	81.76	81.76	1810.0
2009-03-26 05:00:00	SPY	ETF	81.82	82.05	81.74	81.81	55500.0
2009-03-26 06:00:00	SPY	ETF	81.8	82.18	81.8	82.04	58343.0
2009-03-26 07:00:00	SPY	ETF	82.01	82.28	81.85	82.22	1543625.0
2009-03-26 08:00:00	SPY	ETF	82.23	82.54	81.87	82.22	7054291.0
2009-03-26 09:00:00	SPY	ETF	82.21	82.7	81.74	81.84	50712048.0
2009-03-26 10:00:00	SPY	ETF	81.83	82.28	81.48	82.01	52698980.0
2009-03-26 11:00:00	SPY	ETF	82.01	82.5	81.92	82.195	41636788.0
2009-03-26 12:00:00	SPY	ETF	82.2	82.65	82.02	82.12	46212434.0
2009-03-26 13:00:00	SPY	ETF	82.12	83.25	82.1	82.77	56990503.0
2009-03-26 14:00:00	SPY	ETF	82.77	83.21	82.06	82.09	50198343.0
2009-03-26 15:00:00	SPY	ETF	82.0801	83.3	82.04	83.17	91321684.0
2009-03-26 16:00:00	SPY	ETF	83.07	83.41	81.3721	83.04	13481494.0
2009-03-26 17:00:00	SPY	ETF	83.03	83.27	83.02	83.16	8151454.0
2009-03-26 18:00:00	SPY	ETF	83.15	83.36	83.06	83.06	374417.0
2009-03-26 19:00:00	SPY	ETF	83.08	83.11	82.99	82.99	99003.0
2009-03-26 04:00:00	QQQ	ETF	30.79	30.79	30.67	30.67	1450.0
2009-03-26 05:00:00	QQQ	ETF	30.7	30.7	30.7	30.7	100.0
2009-03-26 06:00:00	QQQ	ETF	30.71	30.74	30.71	30.72	11870.0
2009-03-26 07:00:00	QQQ	ETF	30.67	30.81	30.67	30.81	994682.0
2009-03-26 08:00:00	QQQ	ETF	30.81	31.0	30.71	30.86	3861112.0
2009-03-26 09:00:00	QQQ	ETF	30.86	31.09	30.76	30.86	20215513.0
2009-03-26 10:00:00	QQQ	ETF	30.86	31.03	30.75	30.95	21482380.0
2009-03-26 11:00:00	QQQ	ETF	30.95	31.17	30.92	31.1	17284040.0
2009-03-26 12:00:00	QQQ	ETF	31.09	31.28	31.05	31.08	17541483.0
2009-03-26 13:00:00	QQQ	ETF	31.07	31.45	31.065	31.3	26177948.0
2009-03-26 14:00:00	QQQ	ETF	31.31	31.43	31.04	31.06	20667916.0
2009-03-26 15:00:00	QQQ	ETF	31.055	31.46	30.417	31.44	38889376.0
2009-03-26 16:00:00	QQQ	ETF	31.43	31.54	31.1489	31.37	10334836.0
2009-03-26 17:00:00	QQQ	ETF	30.417	31.43	30.417	31.37	2080415.0
2009-03-26 18:00:00	QQQ	ETF	31.38	31.43	31.33	31.33	130486.0
2009-03-26 19:00:00	QQQ	ETF	31.31	31.35	31.31	31.33	14839.0
2009-03-26 07:00:00	IWM	ETF	43.02	43.21	42.92	43.14	88833.0
2009-03-26 08:00:00	IWM	ETF	43.11	43.36	42.96	43.26	785988.0
2009-03-26 09:00:00	IWM	ETF	43.27	43.55	42.92	43.0	10068752.0
2009-03-26 10:00:00	IWM	ETF	43.01	43.4	42.87	43.22	10094591.0
2009-03-26 11:00:00	IWM	ETF	43.22	43.66	43.18	43.47	8496591.0
2009-03-26 12:00:00	IWM	ETF	43.48	43.93	43.43	43.58	9380943.0
2009-03-26 13:00:00	IWM	ETF	43.58	44.31	43.57	43.84	17446056.0
2009-03-26 14:00:00	IWM	ETF	43.85	44.17	43.44	43.46	12665916.0
2009-03-26 15:00:00	IWM	ETF	43.47	44.47	43.38	44.41	27462783.0
2009-03-26 16:00:00	IWM	ETF	44.41	44.64	42.6029	44.29	4265532.0
2009-03-26 17:00:00	IWM	ETF	44.31	44.44	42.6029	42.603	2306454.0
2009-03-26 18:00:00	IWM	ETF	44.38	44.45	44.38	44.38	3400.0
2009-03-26 19:00:00	IWM	ETF	44.4	44.4	44.4	44.4	1000.0
2009-03-26 06:00:00	DIA	ETF	77.95	78.08	77.95	78.03	800.0
2009-03-26 07:00:00	DIA	ETF	77.94	78.23	77.94	78.14	7650.0
2009-03-26 08:00:00	DIA	ETF	78.17	78.37	77.85	78.11	107793.0
2009-03-26 09:00:00	DIA	ETF	78.11	78.54	77.85	77.9	3387751.0
2009-03-26 10:00:00	DIA	ETF	77.92	78.19	77.52	77.98	3284173.0

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

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