PREVIEW / etf_1hour / 2008-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-07-10.parquet
  size:    110 KB
  rows:    3,491

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-07-10 04:00:00	SPY	ETF	124.83	124.99	124.7	124.99	35000.0
2008-07-10 05:00:00	SPY	ETF	125.05	125.05	124.87	124.87	51200.0
2008-07-10 06:00:00	SPY	ETF	124.9	124.91	124.64	124.64	116500.0
2008-07-10 07:00:00	SPY	ETF	124.7	125.8	124.65	125.35	2361358.0
2008-07-10 08:00:00	SPY	ETF	125.35	125.79	124.6	124.61	14317581.0
2008-07-10 09:00:00	SPY	ETF	124.57	125.27	124.1	124.53	54435380.0
2008-07-10 10:00:00	SPY	ETF	124.53	124.84	123.65	124.3	83304286.0
2008-07-10 11:00:00	SPY	ETF	124.31	125.08	124.08	124.77	52512549.0
2008-07-10 12:00:00	SPY	ETF	124.78	125.37	124.5	124.59	32245305.0
2008-07-10 13:00:00	SPY	ETF	124.59	125.79	124.59	125.38	39804429.0
2008-07-10 14:00:00	SPY	ETF	125.39	125.41	123.58	123.88	64915656.0
2008-07-10 15:00:00	SPY	ETF	123.8899	125.41	123.84	125.38	76238525.0
2008-07-10 16:00:00	SPY	ETF	125.46	125.66	124.4373	125.63	6910689.0
2008-07-10 17:00:00	SPY	ETF	125.63	125.67	125.49	125.53	443587.0
2008-07-10 18:00:00	SPY	ETF	125.51	125.58	125.43	125.58	58357.0
2008-07-10 19:00:00	SPY	ETF	125.62	125.65	125.41	125.5	13490.0
2008-07-10 04:00:00	QQQ	ETF	45.0	45.0	45.0	45.0	500.0
2008-07-10 05:00:00	QQQ	ETF	45.03	45.03	45.03	45.03	300.0
2008-07-10 06:00:00	QQQ	ETF	44.91	44.91	44.89	44.89	1800.0
2008-07-10 07:00:00	QQQ	ETF	44.89	45.29	44.88	45.1	1183884.0
2008-07-10 08:00:00	QQQ	ETF	45.11	45.22	44.86	44.86	5186690.0
2008-07-10 09:00:00	QQQ	ETF	44.86	45.3	44.65	44.99	27416025.0
2008-07-10 10:00:00	QQQ	ETF	45.0	45.27	44.72	45.05	41768216.0
2008-07-10 11:00:00	QQQ	ETF	45.04	45.23	44.9	45.05	21127024.0
2008-07-10 12:00:00	QQQ	ETF	45.04	45.32	44.96	45.001	17892659.0
2008-07-10 13:00:00	QQQ	ETF	45.02	45.42	45.02	45.21	15062417.0
2008-07-10 14:00:00	QQQ	ETF	45.21	45.28	44.38	44.51	43010109.0
2008-07-10 15:00:00	QQQ	ETF	44.5	45.28	44.48	45.27	54061663.0
2008-07-10 16:00:00	QQQ	ETF	45.26	45.34	44.9762	45.32	5015620.0
2008-07-10 17:00:00	QQQ	ETF	45.32	45.39	45.32	45.38	75404.0
2008-07-10 18:00:00	QQQ	ETF	45.36	45.36	45.3	45.34	114685.0
2008-07-10 19:00:00	QQQ	ETF	45.33	45.36	45.31	45.36	22290.0
2008-07-10 05:00:00	IWM	ETF	66.58	66.58	66.58	66.58	300.0
2008-07-10 06:00:00	IWM	ETF	66.45	66.45	66.45	66.45	300.0
2008-07-10 07:00:00	IWM	ETF	66.53	66.9	66.52	66.73	376936.0
2008-07-10 08:00:00	IWM	ETF	66.65	67.31	66.29	66.3	2766062.0
2008-07-10 09:00:00	IWM	ETF	66.28	67.01	66.04	66.65	15872312.0
2008-07-10 10:00:00	IWM	ETF	66.65	67.11	65.96	66.68	27242058.0
2008-07-10 11:00:00	IWM	ETF	66.68	66.96	66.39	66.82	13791103.0
2008-07-10 12:00:00	IWM	ETF	66.83	67.25	66.62	66.74	9645779.0
2008-07-10 13:00:00	IWM	ETF	66.74	67.45	66.73	67.15	12950825.0
2008-07-10 14:00:00	IWM	ETF	67.15	67.22	65.98	66.1	17783828.0
2008-07-10 15:00:00	IWM	ETF	66.09	66.93	66.08	66.93	21067638.0
2008-07-10 16:00:00	IWM	ETF	66.93	67.06	66.69	67.0	3573573.0
2008-07-10 17:00:00	IWM	ETF	66.99	67.08	66.96	67.08	74935.0
2008-07-10 18:00:00	IWM	ETF	67.0	67.0	66.97	66.97	3975.0
2008-07-10 19:00:00	IWM	ETF	66.95	66.95	66.8	66.8	9300.0
2008-07-10 06:00:00	DIA	ETF	111.72	111.73	111.72	111.73	400.0
2008-07-10 07:00:00	DIA	ETF	111.97	112.39	111.97	112.17	4671.0
2008-07-10 08:00:00	DIA	ETF	112.18	112.48	111.7	111.7	206905.0

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

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