PREVIEW / etf_1hour / 2010-12-10

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-10.parquet
  size:    171 KB
  rows:    5,181

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
2010-12-10 04:00:00	SPY	ETF	124.1	124.1	124.1	124.1	100.0
2010-12-10 05:00:00	SPY	ETF	124.01	124.24	124.0	124.24	22500.0
2010-12-10 06:00:00	SPY	ETF	124.17	124.17	124.07	124.1	6600.0
2010-12-10 07:00:00	SPY	ETF	124.1	124.24	124.07	124.23	279110.0
2010-12-10 08:00:00	SPY	ETF	124.23	124.31	123.97	124.0	1131031.0
2010-12-10 09:00:00	SPY	ETF	124.0	124.21	123.9	124.01	15789916.0
2010-12-10 10:00:00	SPY	ETF	124.01	124.02	123.73	123.96	15752520.0
2010-12-10 11:00:00	SPY	ETF	123.96	124.16	123.91	124.15	11582894.0
2010-12-10 12:00:00	SPY	ETF	124.15	124.35	124.09	124.26	11818888.0
2010-12-10 13:00:00	SPY	ETF	124.2601	124.47	124.23	124.45	8161774.0
2010-12-10 14:00:00	SPY	ETF	124.45	124.51	124.34	124.48	10925337.0
2010-12-10 15:00:00	SPY	ETF	124.49	124.6	124.32	124.51	30216181.0
2010-12-10 16:00:00	SPY	ETF	124.5	124.63	123.9	124.6	10744899.0
2010-12-10 17:00:00	SPY	ETF	124.61	124.65	124.52	124.55	195726.0
2010-12-10 18:00:00	SPY	ETF	124.54	124.57	124.5	124.54	85270.0
2010-12-10 19:00:00	SPY	ETF	124.53	124.6	124.51	124.56	34865.0
2010-12-10 06:00:00	QQQ	ETF	54.3	54.32	54.22	54.23	1800.0
2010-12-10 07:00:00	QQQ	ETF	54.23	54.3	54.22	54.3	176939.0
2010-12-10 08:00:00	QQQ	ETF	54.24	54.32	54.18	54.19	328040.0
2010-12-10 09:00:00	QQQ	ETF	54.2	54.33	54.15	54.2	7090871.0
2010-12-10 10:00:00	QQQ	ETF	54.2	54.31	54.09	54.28	9651329.0
2010-12-10 11:00:00	QQQ	ETF	54.27	54.33	54.23	54.325	2247488.0
2010-12-10 12:00:00	QQQ	ETF	54.325	54.46	54.3	54.43	3302486.0
2010-12-10 13:00:00	QQQ	ETF	54.422	54.52	54.4	54.515	2991159.0
2010-12-10 14:00:00	QQQ	ETF	54.51	54.53	54.44	54.5	2303221.0
2010-12-10 15:00:00	QQQ	ETF	54.509	54.55	54.42	54.51	10330657.0
2010-12-10 16:00:00	QQQ	ETF	54.51	54.56	54.4351	54.55	3465780.0
2010-12-10 17:00:00	QQQ	ETF	54.55	54.56	54.51	54.52	9622.0
2010-12-10 18:00:00	QQQ	ETF	54.55	54.68	54.51	54.58	23303.0
2010-12-10 19:00:00	QQQ	ETF	54.56	54.58	54.5	54.5	12450.0
2010-12-10 07:00:00	IWM	ETF	77.0	77.15	76.97	77.12	167830.0
2010-12-10 08:00:00	IWM	ETF	77.12	77.16	76.93	76.96	408410.0
2010-12-10 09:00:00	IWM	ETF	76.96	77.07	76.84	76.94	4448483.0
2010-12-10 10:00:00	IWM	ETF	76.95	77.06	76.77	76.99	4523254.0
2010-12-10 11:00:00	IWM	ETF	76.99	77.16	76.96	77.1501	2509687.0
2010-12-10 12:00:00	IWM	ETF	77.15	77.509	77.12	77.44	3968082.0
2010-12-10 13:00:00	IWM	ETF	77.45	77.71	77.37	77.7	4511940.0
2010-12-10 14:00:00	IWM	ETF	77.69	77.94	77.67	77.92	7654363.0
2010-12-10 15:00:00	IWM	ETF	77.92	77.93	77.68	77.76	9981456.0
2010-12-10 16:00:00	IWM	ETF	77.76	77.83	76.88	77.8	1840642.0
2010-12-10 17:00:00	IWM	ETF	77.8	77.82	77.74	77.74	50298.0
2010-12-10 18:00:00	IWM	ETF	77.9	77.9	77.79	77.79	1398.0
2010-12-10 19:00:00	IWM	ETF	77.82	77.84	77.8	77.84	9300.0
2010-12-10 07:00:00	DIA	ETF	114.09	114.18	114.09	114.18	600.0
2010-12-10 08:00:00	DIA	ETF	114.17	114.18	113.93	113.95	18671.0
2010-12-10 09:00:00	DIA	ETF	113.99	114.15	113.89	113.99	694403.0
2010-12-10 10:00:00	DIA	ETF	113.99	113.99	113.77	113.95	776994.0
2010-12-10 11:00:00	DIA	ETF	113.95	114.04	113.88	114.04	653983.0
2010-12-10 12:00:00	DIA	ETF	114.04	114.18	113.99	114.1	392750.0
2010-12-10 13:00:00	DIA	ETF	114.1093	114.2	114.05	114.19	221763.0

> showing 50 of 5,181 rows — these rows as CSV

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