PREVIEW / etf_1hour / 2008-08-08

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-08.parquet
  size:    111 KB
  rows:    3,569

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-08-08 04:00:00	SPY	ETF	127.31	127.52	127.3	127.52	1600.0
2008-08-08 05:00:00	SPY	ETF	127.31	127.31	127.31	127.31	100.0
2008-08-08 06:00:00	SPY	ETF	127.45	127.54	127.25	127.45	233100.0
2008-08-08 07:00:00	SPY	ETF	127.42	127.5	126.8	126.9	1151729.0
2008-08-08 08:00:00	SPY	ETF	126.92	127.36	126.7	126.9	3839231.0
2008-08-08 09:00:00	SPY	ETF	126.88	127.48	126.38	127.36	45800351.0
2008-08-08 10:00:00	SPY	ETF	127.36	128.82	127.27	128.5	62608076.0
2008-08-08 11:00:00	SPY	ETF	128.5	128.69	128.32	128.53	25902618.0
2008-08-08 12:00:00	SPY	ETF	128.53	129.11	128.47	128.94	19643823.0
2008-08-08 13:00:00	SPY	ETF	128.94	129.65	128.891	129.38	26085272.0
2008-08-08 14:00:00	SPY	ETF	129.38	129.82	129.32	129.59	22775010.0
2008-08-08 15:00:00	SPY	ETF	129.6	129.93	127.2	129.62	38612414.0
2008-08-08 16:00:00	SPY	ETF	129.59	129.7217	129.4	129.46	10628686.0
2008-08-08 17:00:00	SPY	ETF	129.46	129.55	129.32	129.5	248566.0
2008-08-08 18:00:00	SPY	ETF	129.51	129.51	129.37	129.41	33963.0
2008-08-08 19:00:00	SPY	ETF	129.38	129.39	129.28	129.33	39690.0
2008-08-08 04:00:00	QQQ	ETF	46.53	46.53	46.44	46.44	500.0
2008-08-08 07:00:00	QQQ	ETF	46.5	46.5	46.31	46.34	554912.0
2008-08-08 08:00:00	QQQ	ETF	46.34	46.48	46.3	46.38	2644837.0
2008-08-08 09:00:00	QQQ	ETF	46.38	46.73	46.15	46.6599	27313264.0
2008-08-08 10:00:00	QQQ	ETF	46.65	47.06	46.64	46.84	30410764.0
2008-08-08 11:00:00	QQQ	ETF	46.84	47.06	46.79	47.02	11565005.0
2008-08-08 12:00:00	QQQ	ETF	47.0219	47.21	46.97	47.13	11369349.0
2008-08-08 13:00:00	QQQ	ETF	47.13	47.35	47.1	47.21	15502528.0
2008-08-08 14:00:00	QQQ	ETF	47.21	47.41	47.18	47.33	17033184.0
2008-08-08 15:00:00	QQQ	ETF	47.33	47.44	47.2	47.32	20910525.0
2008-08-08 16:00:00	QQQ	ETF	47.32	47.37	47.0756	47.27	4817124.0
2008-08-08 17:00:00	QQQ	ETF	47.27	47.27	47.25	47.27	39675.0
2008-08-08 18:00:00	QQQ	ETF	47.29	47.32	47.24	47.25	78730.0
2008-08-08 19:00:00	QQQ	ETF	47.26	47.28	47.25	47.27	17788.0
2008-08-08 06:00:00	IWM	ETF	71.67	71.71	71.63	71.71	13100.0
2008-08-08 07:00:00	IWM	ETF	71.75	71.75	71.34	71.35	224100.0
2008-08-08 08:00:00	IWM	ETF	71.38	71.54	71.32	71.4	697516.0
2008-08-08 09:00:00	IWM	ETF	71.39	72.08	70.98	71.96	16129210.0
2008-08-08 10:00:00	IWM	ETF	71.97	73.0	71.91	72.8	26562409.0
2008-08-08 11:00:00	IWM	ETF	72.8	72.92	72.55	72.72	10576612.0
2008-08-08 12:00:00	IWM	ETF	72.71	72.95	72.65	72.83	5608212.0
2008-08-08 13:00:00	IWM	ETF	72.84	73.33	72.78	73.1	11174381.0
2008-08-08 14:00:00	IWM	ETF	73.1	73.32	72.85	73.15	9371685.0
2008-08-08 15:00:00	IWM	ETF	73.15	73.37	72.91	73.06	15257899.0
2008-08-08 16:00:00	IWM	ETF	73.05	73.24	72.72	73.09	8555448.0
2008-08-08 17:00:00	IWM	ETF	73.09	73.09	71.17	73.01	1002840.0
2008-08-08 18:00:00	IWM	ETF	73.08	73.08	73.08	73.08	600.0
2008-08-08 06:00:00	DIA	ETF	114.95	114.95	114.95	114.95	200.0
2008-08-08 07:00:00	DIA	ETF	114.97	115.05	114.57	114.57	216000.0
2008-08-08 08:00:00	DIA	ETF	114.65	114.75	114.42	114.54	105454.0
2008-08-08 09:00:00	DIA	ETF	114.53	115.07	114.0	114.99	3790803.0
2008-08-08 10:00:00	DIA	ETF	115.01	116.51	114.94	116.22	7347673.0
2008-08-08 11:00:00	DIA	ETF	116.23	116.51	116.09	116.29	2651385.0
2008-08-08 12:00:00	DIA	ETF	116.29	116.81	116.22	116.67	2315708.0

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

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