PREVIEW / etf_1hour / 2008-08-27

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-08-27.parquet
  size:    107 KB
  rows:    3,450

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-27 05:00:00	SPY	ETF	127.09	127.09	126.98	127.01	6600.0
2008-08-27 06:00:00	SPY	ETF	127.09	127.15	127.01	127.04	126000.0
2008-08-27 07:00:00	SPY	ETF	127.02	127.3	127.02	127.19	278541.0
2008-08-27 08:00:00	SPY	ETF	127.15	127.99	127.01	127.77	5907553.0
2008-08-27 09:00:00	SPY	ETF	127.76	127.8	127.3	127.46	17004748.0
2008-08-27 10:00:00	SPY	ETF	127.45	128.29	127.39	128.06	28223056.0
2008-08-27 11:00:00	SPY	ETF	128.06	128.08	127.66	127.93	16371239.0
2008-08-27 12:00:00	SPY	ETF	127.93	128.83	127.79	128.7	31789225.0
2008-08-27 13:00:00	SPY	ETF	128.7	128.73	128.4	128.45	12718987.0
2008-08-27 14:00:00	SPY	ETF	128.45	128.8	128.29	128.4708	16604965.0
2008-08-27 15:00:00	SPY	ETF	128.48	128.64	127.97	128.46	30298656.0
2008-08-27 16:00:00	SPY	ETF	128.39	128.62	127.46	128.44	6845568.0
2008-08-27 17:00:00	SPY	ETF	128.45	128.5	128.4	128.42	457650.0
2008-08-27 18:00:00	SPY	ETF	128.42	128.53	128.41	128.41	131855.0
2008-08-27 19:00:00	SPY	ETF	128.49	128.5	128.43	128.44	13508.0
2008-08-27 06:00:00	QQQ	ETF	46.32	46.33	46.32	46.33	1200.0
2008-08-27 07:00:00	QQQ	ETF	46.34	46.41	46.34	46.4	295072.0
2008-08-27 08:00:00	QQQ	ETF	46.39	46.62	46.35	46.54	2961511.0
2008-08-27 09:00:00	QQQ	ETF	46.54	46.56	46.29	46.3801	10567813.0
2008-08-27 10:00:00	QQQ	ETF	46.38	46.71	46.37	46.59	18420273.0
2008-08-27 11:00:00	QQQ	ETF	46.59	46.62	46.44	46.54	7363485.0
2008-08-27 12:00:00	QQQ	ETF	46.54	47.04	46.51	47.01	16875300.0
2008-08-27 13:00:00	QQQ	ETF	47.01	47.02	46.86	47.0	9855747.0
2008-08-27 14:00:00	QQQ	ETF	46.91	47.09	46.86	46.912	12789659.0
2008-08-27 15:00:00	QQQ	ETF	46.91	46.96	46.58	46.75	22072907.0
2008-08-27 16:00:00	QQQ	ETF	46.75	46.79	46.6	46.67	3371205.0
2008-08-27 17:00:00	QQQ	ETF	46.68	46.7	46.68	46.68	17656.0
2008-08-27 18:00:00	QQQ	ETF	46.7	46.7	46.7	46.7	2000.0
2008-08-27 19:00:00	QQQ	ETF	46.7	46.71	46.68	46.68	11149.0
2008-08-27 07:00:00	IWM	ETF	72.03	72.22	72.02	72.13	357180.0
2008-08-27 08:00:00	IWM	ETF	72.11	72.49	71.88	72.35	1751853.0
2008-08-27 09:00:00	IWM	ETF	72.34	72.61	72.11	72.37	6194653.0
2008-08-27 10:00:00	IWM	ETF	72.37	73.05	72.34	72.85	11311236.0
2008-08-27 11:00:00	IWM	ETF	72.86	72.92	72.64	72.77	5735036.0
2008-08-27 12:00:00	IWM	ETF	72.77	73.51	72.73	73.42	9264727.0
2008-08-27 13:00:00	IWM	ETF	73.41	73.42	73.16	73.17	2720423.0
2008-08-27 14:00:00	IWM	ETF	73.18	73.48	73.1	73.19	5051401.0
2008-08-27 15:00:00	IWM	ETF	73.19	73.4	72.75	73.02	13779525.0
2008-08-27 16:00:00	IWM	ETF	73.02	73.15	72.9	72.99	3885237.0
2008-08-27 17:00:00	IWM	ETF	73.0	73.08	72.98	73.02	104885.0
2008-08-27 18:00:00	IWM	ETF	73.02	73.02	73.0	73.0	3734.0
2008-08-27 19:00:00	IWM	ETF	73.0	73.0	72.96	72.96	300.0
2008-08-27 05:00:00	DIA	ETF	114.04	114.04	114.04	114.04	200.0
2008-08-27 07:00:00	DIA	ETF	114.0	114.0	113.91	113.96	32182.0
2008-08-27 08:00:00	DIA	ETF	113.96	114.58	113.83	114.43	318306.0
2008-08-27 09:00:00	DIA	ETF	114.41	114.41	113.84	113.97	1567052.0
2008-08-27 10:00:00	DIA	ETF	113.95	114.92	113.89	114.78	2932733.0
2008-08-27 11:00:00	DIA	ETF	114.77	114.87	114.49	114.69	1773089.0
2008-08-27 12:00:00	DIA	ETF	114.7	115.59	114.57	115.45	2585550.0
2008-08-27 13:00:00	DIA	ETF	115.45	115.49	115.13	115.17	1023126.0

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

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