PREVIEW / etf_1hour / 2009-04-29

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-04-29.parquet
  size:    135 KB
  rows:    4,144

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-04-29 04:00:00	SPY	ETF	86.29	86.33	86.12	86.12	4726.0
2009-04-29 05:00:00	SPY	ETF	86.17	86.71	86.17	86.71	38900.0
2009-04-29 06:00:00	SPY	ETF	86.64	86.66	86.43	86.47	48828.0
2009-04-29 07:00:00	SPY	ETF	86.45	86.5	86.27	86.48	646040.0
2009-04-29 08:00:00	SPY	ETF	86.47	86.75	86.14	86.44	6294614.0
2009-04-29 09:00:00	SPY	ETF	86.44	86.94	86.2	86.91	27342090.0
2009-04-29 10:00:00	SPY	ETF	86.91	87.56	86.6	87.39	41042191.0
2009-04-29 11:00:00	SPY	ETF	87.39	87.61	87.24	87.35	27895123.0
2009-04-29 12:00:00	SPY	ETF	87.35	87.48	87.25	87.3701	21603130.0
2009-04-29 13:00:00	SPY	ETF	87.37	87.88	87.36	87.68	22320887.0
2009-04-29 14:00:00	SPY	ETF	87.68	88.36	87.41	87.83	64414256.0
2009-04-29 15:00:00	SPY	ETF	87.83	87.97	86.35	87.44	73772403.0
2009-04-29 16:00:00	SPY	ETF	87.39	87.53	86.4	87.35	16008520.0
2009-04-29 17:00:00	SPY	ETF	87.35	88.24	85.6376	87.41	9205184.0
2009-04-29 18:00:00	SPY	ETF	87.45	87.45	87.1	87.12	138747.0
2009-04-29 19:00:00	SPY	ETF	87.14	87.24	87.13	87.18	58695.0
2009-04-29 04:00:00	QQQ	ETF	33.73	33.73	33.67	33.67	330.0
2009-04-29 05:00:00	QQQ	ETF	33.68	33.87	33.68	33.87	3800.0
2009-04-29 06:00:00	QQQ	ETF	33.8	33.8	33.8	33.8	1000.0
2009-04-29 07:00:00	QQQ	ETF	33.8	33.82	33.75	33.78	308135.0
2009-04-29 08:00:00	QQQ	ETF	33.77	33.86	33.5	33.76	2412911.0
2009-04-29 09:00:00	QQQ	ETF	33.76	33.93	33.7	33.93	13415646.0
2009-04-29 10:00:00	QQQ	ETF	33.93	34.17	33.86	34.12	17684585.0
2009-04-29 11:00:00	QQQ	ETF	34.12	34.26	33.9195	34.16	14569523.0
2009-04-29 12:00:00	QQQ	ETF	34.1595	34.2	34.08	34.119	8188549.0
2009-04-29 13:00:00	QQQ	ETF	34.12	34.27	34.11	34.16	10434685.0
2009-04-29 14:00:00	QQQ	ETF	34.16	34.4	34.07	34.24	30012772.0
2009-04-29 15:00:00	QQQ	ETF	34.24	34.29	33.83	33.94	31955649.0
2009-04-29 16:00:00	QQQ	ETF	33.94	34.15	33.88	33.97	4704213.0
2009-04-29 17:00:00	QQQ	ETF	33.97	34.02	33.94	34.0	178366.0
2009-04-29 18:00:00	QQQ	ETF	34.0	34.01	33.91	33.91	143470.0
2009-04-29 19:00:00	QQQ	ETF	33.93	33.94	33.92	33.92	27132.0
2009-04-29 06:00:00	IWM	ETF	47.95	47.95	47.94	47.94	2929.0
2009-04-29 07:00:00	IWM	ETF	47.95	47.96	47.81	47.94	46779.0
2009-04-29 08:00:00	IWM	ETF	47.93	48.07	47.4	47.81	235141.0
2009-04-29 09:00:00	IWM	ETF	47.8	48.09	47.63	48.09	6438839.0
2009-04-29 10:00:00	IWM	ETF	48.09	48.82	47.95	48.76	12025260.0
2009-04-29 11:00:00	IWM	ETF	48.76	49.11	48.67	48.9091	9313653.0
2009-04-29 12:00:00	IWM	ETF	48.91	49.05	48.86	48.96	2761383.0
2009-04-29 13:00:00	IWM	ETF	48.96	49.37	48.95	49.202	7958498.0
2009-04-29 14:00:00	IWM	ETF	49.2	49.57	48.8901	49.24	15389102.0
2009-04-29 15:00:00	IWM	ETF	49.24	49.37	47.75	49.03	16756907.0
2009-04-29 16:00:00	IWM	ETF	49.02	49.21	48.93	49.09	3549009.0
2009-04-29 17:00:00	IWM	ETF	49.05	49.13	49.02	49.12	399321.0
2009-04-29 18:00:00	IWM	ETF	49.08	49.08	48.96	48.96	4050.0
2009-04-29 19:00:00	IWM	ETF	48.97	49.0	48.96	49.0	2200.0
2009-04-29 06:00:00	DIA	ETF	80.95	80.95	80.95	80.95	258.0
2009-04-29 07:00:00	DIA	ETF	80.85	80.92	80.77	80.9	43300.0
2009-04-29 08:00:00	DIA	ETF	80.91	81.05	80.52	80.78	187963.0
2009-04-29 09:00:00	DIA	ETF	80.82	81.31	80.59	81.29	1992599.0

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

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