PREVIEW / etf_1hour / 2008-01-10

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-01-10.parquet
  size:    99 KB
  rows:    3,299

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-10 04:00:00	SPY	ETF	140.03	140.05	139.72	140.05	12100.0
2008-01-10 05:00:00	SPY	ETF	139.97	140.12	139.97	140.12	2000.0
2008-01-10 06:00:00	SPY	ETF	140.07	140.11	139.86	140.11	297300.0
2008-01-10 07:00:00	SPY	ETF	139.91	140.4	139.81	140.24	748700.0
2008-01-10 08:00:00	SPY	ETF	140.18	140.35	139.51	139.78	7447400.0
2008-01-10 09:00:00	SPY	ETF	139.79	140.12	139.37	139.98	25847826.0
2008-01-10 10:00:00	SPY	ETF	139.98	140.78	139.92	140.16	33854470.0
2008-01-10 11:00:00	SPY	ETF	140.16	140.28	139.66	140.17	19540852.0
2008-01-10 12:00:00	SPY	ETF	140.16	142.29	139.94	141.39	78725528.0
2008-01-10 13:00:00	SPY	ETF	141.39	141.57	139.98	140.54	36942610.0
2008-01-10 14:00:00	SPY	ETF	140.54	142.3	140.13	142.13	49177530.0
2008-01-10 15:00:00	SPY	ETF	142.13	142.8	141.71	141.8	59268598.0
2008-01-10 16:00:00	SPY	ETF	141.82	141.96	139.76	141.16	20965300.0
2008-01-10 17:00:00	SPY	ETF	141.16	141.29	141.11	141.23	2132500.0
2008-01-10 18:00:00	SPY	ETF	141.23	141.54	141.19	141.44	47700.0
2008-01-10 19:00:00	SPY	ETF	141.43	141.43	141.19	141.22	25500.0
2008-01-10 04:00:00	QQQ	ETF	47.6	47.6	47.6	47.6	200.0
2008-01-10 05:00:00	QQQ	ETF	47.64	47.66	47.64	47.66	1000.0
2008-01-10 06:00:00	QQQ	ETF	47.65	47.69	47.54	47.55	196000.0
2008-01-10 07:00:00	QQQ	ETF	47.62	47.81	47.55	47.69	609765.0
2008-01-10 08:00:00	QQQ	ETF	47.71	47.95	47.37	47.5	4742024.0
2008-01-10 09:00:00	QQQ	ETF	47.5	47.6	47.29	47.45	24105056.0
2008-01-10 10:00:00	QQQ	ETF	47.45	47.75	47.39	47.5	35512019.0
2008-01-10 11:00:00	QQQ	ETF	47.5	47.63	47.4	47.59	11838693.0
2008-01-10 12:00:00	QQQ	ETF	47.5801	48.35	47.53	48.01	57268827.0
2008-01-10 13:00:00	QQQ	ETF	48.0	48.09	47.48	47.72	30503328.0
2008-01-10 14:00:00	QQQ	ETF	47.72	48.16	47.58	48.11	40427740.0
2008-01-10 15:00:00	QQQ	ETF	48.1	48.41	47.92	48.01	40752513.0
2008-01-10 16:00:00	QQQ	ETF	48.002	48.002	47.48	47.78	4713511.0
2008-01-10 17:00:00	QQQ	ETF	47.99	47.99	47.78	47.78	98084.0
2008-01-10 18:00:00	QQQ	ETF	47.79	47.91	47.79	47.87	17229.0
2008-01-10 19:00:00	QQQ	ETF	47.9	47.9	47.81	47.83	31414.0
2008-01-10 07:00:00	IWM	ETF	70.19	70.61	70.19	70.61	19700.0
2008-01-10 08:00:00	IWM	ETF	70.43	70.59	69.99	70.09	1130300.0
2008-01-10 09:00:00	IWM	ETF	70.1	70.58	69.86	70.47	10979469.0
2008-01-10 10:00:00	IWM	ETF	70.47	70.88	70.34	70.44	13129811.0
2008-01-10 11:00:00	IWM	ETF	70.43	70.64	70.1	70.6	7539467.0
2008-01-10 12:00:00	IWM	ETF	70.6	71.88	70.41	71.61	42379536.0
2008-01-10 13:00:00	IWM	ETF	71.61	71.73	70.62	70.98	19688919.0
2008-01-10 14:00:00	IWM	ETF	70.98	72.11	70.67	72.02	23652693.0
2008-01-10 15:00:00	IWM	ETF	72.03	72.32	71.47	71.71	31116373.0
2008-01-10 16:00:00	IWM	ETF	71.71	71.94	71.09	71.37	4412975.0
2008-01-10 17:00:00	IWM	ETF	71.43	71.49	71.35	71.4	29000.0
2008-01-10 18:00:00	IWM	ETF	71.57	71.57	71.57	71.57	300.0
2008-01-10 19:00:00	IWM	ETF	71.44	71.45	71.44	71.45	500.0
2008-01-10 07:00:00	DIA	ETF	126.7	127.01	126.65	127.01	6500.0
2008-01-10 08:00:00	DIA	ETF	126.88	126.96	126.38	126.55	83200.0
2008-01-10 09:00:00	DIA	ETF	126.55	127.0	126.29	126.91	1805555.0
2008-01-10 10:00:00	DIA	ETF	126.9	127.49	126.81	127.07	2950370.0
2008-01-10 11:00:00	DIA	ETF	127.07	127.29	126.8	127.2	1556448.0

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

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