PREVIEW / etf_1hour / 2010-09-28

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-28.parquet
  size:    168 KB
  rows:    5,093

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-09-28 04:00:00	SPY	ETF	114.17	114.17	113.72	113.82	7940.0
2010-09-28 05:00:00	SPY	ETF	113.73	114.6	113.69	114.55	28367.0
2010-09-28 06:00:00	SPY	ETF	114.63	114.65	114.25	114.28	44000.0
2010-09-28 07:00:00	SPY	ETF	114.3	114.4	114.19	114.24	221385.0
2010-09-28 08:00:00	SPY	ETF	114.24	114.58	114.23	114.43	1086349.0
2010-09-28 09:00:00	SPY	ETF	114.45	114.63	113.6	113.76	29300779.0
2010-09-28 10:00:00	SPY	ETF	113.73	114.07	113.18	114.04	42672095.0
2010-09-28 11:00:00	SPY	ETF	114.04	114.62	113.93	114.36	28429185.0
2010-09-28 12:00:00	SPY	ETF	114.36	114.56	114.21	114.485	12667955.0
2010-09-28 13:00:00	SPY	ETF	114.48	114.81	114.21	114.78	14814359.0
2010-09-28 14:00:00	SPY	ETF	114.78	114.79	114.1	114.225	20335449.0
2010-09-28 15:00:00	SPY	ETF	114.22	115.04	114.15	114.72	43493929.0
2010-09-28 16:00:00	SPY	ETF	114.69	114.9992	114.2164	114.67	12103157.0
2010-09-28 17:00:00	SPY	ETF	114.69	114.78	114.66	114.68	1042668.0
2010-09-28 18:00:00	SPY	ETF	114.68	114.73	114.62	114.7	101762.0
2010-09-28 19:00:00	SPY	ETF	114.69	114.71	114.63	114.66	25560.0
2010-09-28 04:00:00	QQQ	ETF	49.28	49.3	49.25	49.29	2700.0
2010-09-28 05:00:00	QQQ	ETF	49.24	49.62	49.24	49.62	1600.0
2010-09-28 06:00:00	QQQ	ETF	49.56	49.57	49.45	49.51	4650.0
2010-09-28 07:00:00	QQQ	ETF	49.48	49.52	49.43	49.46	24818.0
2010-09-28 08:00:00	QQQ	ETF	49.47	49.61	49.47	49.53	494582.0
2010-09-28 09:00:00	QQQ	ETF	49.54	49.62	48.89	48.93	23983863.0
2010-09-28 10:00:00	QQQ	ETF	48.93	49.25	48.59	49.23	18438181.0
2010-09-28 11:00:00	QQQ	ETF	49.2281	49.45	49.12	49.28	9115261.0
2010-09-28 12:00:00	QQQ	ETF	49.285	49.37	49.11	49.3425	8482670.0
2010-09-28 13:00:00	QQQ	ETF	49.34	49.53	49.2305	49.5299	6511940.0
2010-09-28 14:00:00	QQQ	ETF	49.525	49.54	49.18	49.26	8105003.0
2010-09-28 15:00:00	QQQ	ETF	49.255	49.53	49.2	49.39	15370358.0
2010-09-28 16:00:00	QQQ	ETF	49.39	49.4317	49.0202	49.42	6038084.0
2010-09-28 17:00:00	QQQ	ETF	49.42	49.43	49.4	49.4	77958.0
2010-09-28 18:00:00	QQQ	ETF	49.4	49.43	49.4	49.4	11650.0
2010-09-28 19:00:00	QQQ	ETF	49.42	49.42	49.4	49.42	4445.0
2010-09-28 04:00:00	IWM	ETF	66.55	66.55	66.52	66.52	350.0
2010-09-28 05:00:00	IWM	ETF	66.69	67.18	66.69	67.15	760.0
2010-09-28 06:00:00	IWM	ETF	67.11	67.15	66.91	66.92	23655.0
2010-09-28 07:00:00	IWM	ETF	67.0	67.0	66.87	66.96	21900.0
2010-09-28 08:00:00	IWM	ETF	66.91	67.1	66.38	66.97	124807.0
2010-09-28 09:00:00	IWM	ETF	66.99	67.05	65.87	66.17	8767133.0
2010-09-28 10:00:00	IWM	ETF	66.22	66.71	65.749	66.69	10816603.0
2010-09-28 11:00:00	IWM	ETF	66.6801	67.06	66.54	66.79	7364133.0
2010-09-28 12:00:00	IWM	ETF	66.8	67.02	66.65	66.97	3354225.0
2010-09-28 13:00:00	IWM	ETF	66.97	67.205	66.75	67.19	4876231.0
2010-09-28 14:00:00	IWM	ETF	67.2	67.25	66.57	66.77	5729325.0
2010-09-28 15:00:00	IWM	ETF	66.77	67.63	66.68	67.49	15098470.0
2010-09-28 16:00:00	IWM	ETF	67.46	67.5312	66.5459	67.45	2526014.0
2010-09-28 17:00:00	IWM	ETF	67.46	67.46	66.8179	67.4	503840.0
2010-09-28 18:00:00	IWM	ETF	67.57	67.57	67.44	67.45	416.0
2010-09-28 19:00:00	IWM	ETF	67.45	67.45	67.41	67.41	400.0
2010-09-28 06:00:00	DIA	ETF	108.19	108.19	108.19	108.19	800.0
2010-09-28 07:00:00	DIA	ETF	108.26	108.26	108.24	108.24	2100.0

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

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