PREVIEW / etf_1hour / 2010-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-09-29.parquet
  size:    164 KB
  rows:    5,074

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-29 04:00:00	SPY	ETF	114.5	114.54	114.19	114.21	13480.0
2010-09-29 05:00:00	SPY	ETF	114.4	114.75	114.35	114.64	13260.0
2010-09-29 06:00:00	SPY	ETF	114.64	114.64	114.41	114.54	7360.0
2010-09-29 07:00:00	SPY	ETF	114.59	114.69	114.4	114.69	313055.0
2010-09-29 08:00:00	SPY	ETF	114.7	114.81	114.39	114.41	2425348.0
2010-09-29 09:00:00	SPY	ETF	114.42	114.68	114.2	114.33	25439973.0
2010-09-29 10:00:00	SPY	ETF	114.34	114.65	114.02	114.2499	33345221.0
2010-09-29 11:00:00	SPY	ETF	114.24	114.74	114.21	114.67	18536534.0
2010-09-29 12:00:00	SPY	ETF	114.66	114.86	114.57	114.68	13846568.0
2010-09-29 13:00:00	SPY	ETF	114.68	114.78	114.43	114.725	15418642.0
2010-09-29 14:00:00	SPY	ETF	114.73	114.91	114.66	114.82	12677775.0
2010-09-29 15:00:00	SPY	ETF	114.83	114.84	114.07	114.43	43492410.0
2010-09-29 16:00:00	SPY	ETF	114.43	114.805	114.125	114.51	12957146.0
2010-09-29 17:00:00	SPY	ETF	114.51	114.54	114.43	114.48	106885.0
2010-09-29 18:00:00	SPY	ETF	114.41	114.54	114.41	114.5	29284.0
2010-09-29 19:00:00	SPY	ETF	114.5	114.5	114.45	114.47	59877.0
2010-09-29 05:00:00	QQQ	ETF	49.27	49.35	49.27	49.35	9000.0
2010-09-29 06:00:00	QQQ	ETF	49.36	49.36	49.36	49.36	100.0
2010-09-29 07:00:00	QQQ	ETF	49.34	49.38	49.31	49.38	15715.0
2010-09-29 08:00:00	QQQ	ETF	49.4	49.48	49.32	49.32	210131.0
2010-09-29 09:00:00	QQQ	ETF	49.31	49.53	49.2	49.32	11893711.0
2010-09-29 10:00:00	QQQ	ETF	49.31	49.5	49.13	49.23	10585303.0
2010-09-29 11:00:00	QQQ	ETF	49.23	49.42	49.22	49.36	5499413.0
2010-09-29 12:00:00	QQQ	ETF	49.37	49.45	49.28	49.35	7708237.0
2010-09-29 13:00:00	QQQ	ETF	49.355	49.39	49.18	49.36	8127605.0
2010-09-29 14:00:00	QQQ	ETF	49.355	49.44	49.3	49.42	3979238.0
2010-09-29 15:00:00	QQQ	ETF	49.42	49.43	49.11	49.28	15136137.0
2010-09-29 16:00:00	QQQ	ETF	49.28	49.415	49.21	49.32	10784952.0
2010-09-29 17:00:00	QQQ	ETF	49.33	49.36	49.28	49.28	8988.0
2010-09-29 18:00:00	QQQ	ETF	49.35	49.36	49.34	49.35	12650.0
2010-09-29 19:00:00	QQQ	ETF	49.37	49.37	49.32	49.33	7696.0
2010-09-29 05:00:00	IWM	ETF	67.41	67.41	67.41	67.41	330.0
2010-09-29 06:00:00	IWM	ETF	67.35	67.35	67.32	67.32	900.0
2010-09-29 07:00:00	IWM	ETF	67.35	67.51	67.3	67.51	187700.0
2010-09-29 08:00:00	IWM	ETF	67.35	67.57	67.01	67.33	607906.0
2010-09-29 09:00:00	IWM	ETF	67.32	67.68	67.12	67.33	7121359.0
2010-09-29 10:00:00	IWM	ETF	67.33	67.6	67.14	67.33	6145762.0
2010-09-29 11:00:00	IWM	ETF	67.33	67.83	67.29	67.75	4831839.0
2010-09-29 12:00:00	IWM	ETF	67.75	67.95	67.67	67.82	4578054.0
2010-09-29 13:00:00	IWM	ETF	67.7901	67.835	67.54	67.73	3737744.0
2010-09-29 14:00:00	IWM	ETF	67.73	67.91	67.67	67.86	4829085.0
2010-09-29 15:00:00	IWM	ETF	67.86	67.9	67.43	67.68	15589602.0
2010-09-29 16:00:00	IWM	ETF	67.69	67.7541	67.44	67.7	3399386.0
2010-09-29 17:00:00	IWM	ETF	67.7	67.71	67.68	67.71	25260.0
2010-09-29 18:00:00	IWM	ETF	67.7	67.71	67.68	67.71	5900.0
2010-09-29 19:00:00	IWM	ETF	67.71	67.72	67.7	67.7	1100.0
2010-09-29 04:00:00	DIA	ETF	108.5	108.5	108.5	108.5	100.0
2010-09-29 07:00:00	DIA	ETF	108.51	108.51	108.51	108.51	1000.0
2010-09-29 08:00:00	DIA	ETF	108.57	108.69	108.36	108.38	4300.0
2010-09-29 09:00:00	DIA	ETF	108.36	108.59	108.18	108.3	748355.0

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

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