PREVIEW / etf_1hour / 2010-01-11

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-01-11.parquet
  size:    153 KB
  rows:    4,755

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-01-11 04:00:00	SPY	ETF	115.12	115.17	115.12	115.17	900.0
2010-01-11 05:00:00	SPY	ETF	115.17	115.25	115.17	115.25	20000.0
2010-01-11 06:00:00	SPY	ETF	115.25	115.25	115.05	115.11	33600.0
2010-01-11 07:00:00	SPY	ETF	115.05	115.05	114.95	114.96	148350.0
2010-01-11 08:00:00	SPY	ETF	114.99	115.12	114.9	115.01	1509623.0
2010-01-11 09:00:00	SPY	ETF	115.01	115.13	114.6	114.63	14716949.0
2010-01-11 10:00:00	SPY	ETF	114.6301	114.74	114.37	114.6	18312420.0
2010-01-11 11:00:00	SPY	ETF	114.61	114.64	114.29	114.55	12579394.0
2010-01-11 12:00:00	SPY	ETF	114.56	114.6	114.24	114.355	8805481.0
2010-01-11 13:00:00	SPY	ETF	114.36	114.54	114.3	114.51	7223893.0
2010-01-11 14:00:00	SPY	ETF	114.51	114.59	114.41	114.54	9247429.0
2010-01-11 15:00:00	SPY	ETF	114.52	114.86	114.235	114.73	21576972.0
2010-01-11 16:00:00	SPY	ETF	114.74	114.77	114.38	114.45	4851623.0
2010-01-11 17:00:00	SPY	ETF	114.45	114.52	114.39	114.52	817095.0
2010-01-11 18:00:00	SPY	ETF	114.51	114.6	114.41	114.42	236875.0
2010-01-11 19:00:00	SPY	ETF	114.4	115.12	114.4	114.57	233624.0
2010-01-11 04:00:00	QQQ	ETF	46.73	46.76	46.73	46.76	1300.0
2010-01-11 05:00:00	QQQ	ETF	46.72	46.77	46.72	46.77	4686.0
2010-01-11 06:00:00	QQQ	ETF	46.76	46.76	46.67	46.68	47419.0
2010-01-11 07:00:00	QQQ	ETF	46.68	46.69	46.61	46.62	199565.0
2010-01-11 08:00:00	QQQ	ETF	46.62	46.8	46.59	46.61	1897994.0
2010-01-11 09:00:00	QQQ	ETF	46.61	46.64	46.32	46.32	18451247.0
2010-01-11 10:00:00	QQQ	ETF	46.33	46.43	46.12	46.295	22330181.0
2010-01-11 11:00:00	QQQ	ETF	46.2833	46.32	46.13	46.32	12659733.0
2010-01-11 12:00:00	QQQ	ETF	46.32	46.36	46.17	46.2281	9499124.0
2010-01-11 13:00:00	QQQ	ETF	46.22	46.285	46.19	46.238	2939290.0
2010-01-11 14:00:00	QQQ	ETF	46.24	46.26	46.17	46.21	7688025.0
2010-01-11 15:00:00	QQQ	ETF	46.21	46.43	46.2	46.37	15839565.0
2010-01-11 16:00:00	QQQ	ETF	46.36	46.4173	46.22	46.23	5794889.0
2010-01-11 17:00:00	QQQ	ETF	46.25	46.28	46.23	46.24	79826.0
2010-01-11 18:00:00	QQQ	ETF	46.23	46.27	46.23	46.24	11642.0
2010-01-11 19:00:00	QQQ	ETF	46.28	46.32	46.28	46.31	38329.0
2010-01-11 07:00:00	IWM	ETF	64.8	64.89	64.8	64.84	3855.0
2010-01-11 08:00:00	IWM	ETF	64.99	64.99	64.79	64.87	287413.0
2010-01-11 09:00:00	IWM	ETF	64.87	64.89	64.23	64.235	7333767.0
2010-01-11 10:00:00	IWM	ETF	64.25	64.37	64.01	64.34	7253124.0
2010-01-11 11:00:00	IWM	ETF	64.33	64.35	64.08	64.31	4555747.0
2010-01-11 12:00:00	IWM	ETF	64.32	64.34	64.0804	64.2	2016639.0
2010-01-11 13:00:00	IWM	ETF	64.2	64.22	64.14	64.16	2352504.0
2010-01-11 14:00:00	IWM	ETF	64.17	64.3	64.1	64.205	3666583.0
2010-01-11 15:00:00	IWM	ETF	64.199	64.42	64.17	64.29	11849023.0
2010-01-11 16:00:00	IWM	ETF	64.29	64.4201	63.98	64.03	4688788.0
2010-01-11 17:00:00	IWM	ETF	64.01	64.2	63.99	64.2	506890.0
2010-01-11 18:00:00	IWM	ETF	64.19	64.2	64.07	64.12	12900.0
2010-01-11 19:00:00	IWM	ETF	64.13	64.13	64.06	64.06	400.0
2010-01-11 04:00:00	DIA	ETF	106.51	106.51	106.51	106.51	200.0
2010-01-11 08:00:00	DIA	ETF	106.45	106.87	106.25	106.4	49063.0
2010-01-11 09:00:00	DIA	ETF	106.41	106.48	105.99	106.01	1228107.0
2010-01-11 10:00:00	DIA	ETF	106.02	106.21	105.82	106.2099	1284008.0
2010-01-11 11:00:00	DIA	ETF	106.19	106.255	105.96	106.245	739679.0

> showing 50 of 4,755 rows — these rows as CSV

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