PREVIEW / etf_1hour / 2008-10-21

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-10-21.parquet
  size:    112 KB
  rows:    3,678

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-10-21 04:00:00	SPY	ETF	98.15	98.15	97.63	97.63	500.0
2008-10-21 05:00:00	SPY	ETF	98.18	98.18	98.18	98.18	100.0
2008-10-21 06:00:00	SPY	ETF	98.17	98.43	98.1	98.32	29300.0
2008-10-21 07:00:00	SPY	ETF	98.33	98.43	97.4	97.6	1463871.0
2008-10-21 08:00:00	SPY	ETF	97.6	98.81	97.11	97.33	3685602.0
2008-10-21 09:00:00	SPY	ETF	97.34	98.2	96.41	97.41	36041525.0
2008-10-21 10:00:00	SPY	ETF	97.4	98.64	97.15	97.4	49410167.0
2008-10-21 11:00:00	SPY	ETF	97.4	97.8	95.86	96.0	36261133.0
2008-10-21 12:00:00	SPY	ETF	96.0	96.59	95.42	95.44	43692679.0
2008-10-21 13:00:00	SPY	ETF	95.44	96.94	95.4	96.41	36192498.0
2008-10-21 14:00:00	SPY	ETF	96.4	98.41	96.4	97.76	48003034.0
2008-10-21 15:00:00	SPY	ETF	97.76	98.4	95.22	95.5	79455994.0
2008-10-21 16:00:00	SPY	ETF	95.47	98.5672	93.5055	95.31	17975061.0
2008-10-21 17:00:00	SPY	ETF	95.31	97.0	95.16	96.97	1226070.0
2008-10-21 18:00:00	SPY	ETF	96.9	96.97	96.66	96.74	133965.0
2008-10-21 19:00:00	SPY	ETF	96.74	96.97	96.6	96.62	106663.0
2008-10-21 04:00:00	QQQ	ETF	33.06	33.06	32.9	32.9	1000.0
2008-10-21 05:00:00	QQQ	ETF	32.9	32.9	32.87	32.88	1800.0
2008-10-21 06:00:00	QQQ	ETF	32.94	32.97	32.9	32.9	3400.0
2008-10-21 07:00:00	QQQ	ETF	32.93	32.93	32.64	32.73	249728.0
2008-10-21 08:00:00	QQQ	ETF	32.74	32.85	32.59	32.65	878438.0
2008-10-21 09:00:00	QQQ	ETF	32.66	32.8	32.43	32.77	21334896.0
2008-10-21 10:00:00	QQQ	ETF	32.78	33.25	32.7	32.7	31528195.0
2008-10-21 11:00:00	QQQ	ETF	32.7	32.84	32.06	32.1	23865417.0
2008-10-21 12:00:00	QQQ	ETF	32.1	32.25	31.76	31.76	29014865.0
2008-10-21 13:00:00	QQQ	ETF	31.76	32.28	31.75	32.04	21643567.0
2008-10-21 14:00:00	QQQ	ETF	32.04	32.62	32.03	32.38	23884098.0
2008-10-21 15:00:00	QQQ	ETF	32.38	32.6	31.48	31.51	45368855.0
2008-10-21 16:00:00	QQQ	ETF	31.51	33.2572	31.11	31.21	18252374.0
2008-10-21 17:00:00	QQQ	ETF	31.22	32.58	31.09	32.39	8106015.0
2008-10-21 18:00:00	QQQ	ETF	32.38	32.46	32.34	32.42	700460.0
2008-10-21 19:00:00	QQQ	ETF	32.42	32.5	32.4	32.43	386935.0
2008-10-21 07:00:00	IWM	ETF	54.49	54.66	54.3	54.66	73600.0
2008-10-21 08:00:00	IWM	ETF	53.9	54.73	53.9	54.23	676177.0
2008-10-21 09:00:00	IWM	ETF	54.33	54.51	53.53	53.96	10629756.0
2008-10-21 10:00:00	IWM	ETF	53.96	54.59	53.84	53.9	9470434.0
2008-10-21 11:00:00	IWM	ETF	53.9	54.09	52.97	53.08	10043165.0
2008-10-21 12:00:00	IWM	ETF	53.07	53.59	52.82	52.91	9187193.0
2008-10-21 13:00:00	IWM	ETF	52.9	53.79	52.89	53.6	7036972.0
2008-10-21 14:00:00	IWM	ETF	53.59	54.57	53.58	54.28	9858349.0
2008-10-21 15:00:00	IWM	ETF	54.28	54.51	52.99	53.12	13997180.0
2008-10-21 16:00:00	IWM	ETF	53.13	53.87	52.8	53.3	2082572.0
2008-10-21 17:00:00	IWM	ETF	53.02	53.9	53.02	53.9	44000.0
2008-10-21 18:00:00	IWM	ETF	53.9	53.9	53.9	53.9	300.0
2008-10-21 04:00:00	DIA	ETF	92.11	92.11	92.11	92.11	100.0
2008-10-21 07:00:00	DIA	ETF	92.38	92.89	91.8	91.91	4427.0
2008-10-21 08:00:00	DIA	ETF	91.8	92.0	91.55	91.83	88820.0
2008-10-21 09:00:00	DIA	ETF	91.93	92.2	91.0	91.85	2996681.0
2008-10-21 10:00:00	DIA	ETF	91.85	92.79	91.58	91.77	3282027.0
2008-10-21 11:00:00	DIA	ETF	91.73	92.13	90.4	90.52	3156651.0

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

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