PREVIEW / etf_1hour / 2010-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-28.parquet
  size:    165 KB
  rows:    5,063

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-10-28 04:00:00	SPY	ETF	118.55	118.59	118.55	118.59	250.0
2010-10-28 05:00:00	SPY	ETF	118.72	118.72	118.67	118.71	5750.0
2010-10-28 06:00:00	SPY	ETF	118.62	118.65	118.55	118.55	35600.0
2010-10-28 07:00:00	SPY	ETF	118.57	118.58	118.44	118.56	159219.0
2010-10-28 08:00:00	SPY	ETF	118.52	119.2	118.22	119.0	4489230.0
2010-10-28 09:00:00	SPY	ETF	119.0	119.11	118.62	118.815	16895269.0
2010-10-28 10:00:00	SPY	ETF	118.81	118.94	118.03	118.25	33962906.0
2010-10-28 11:00:00	SPY	ETF	118.26	118.51	118.12	118.15	14652341.0
2010-10-28 12:00:00	SPY	ETF	118.14	118.14	117.83	117.91	17407821.0
2010-10-28 13:00:00	SPY	ETF	117.92	118.53	117.86	118.2101	18979742.0
2010-10-28 14:00:00	SPY	ETF	118.21	118.489	118.17	118.38	19437162.0
2010-10-28 15:00:00	SPY	ETF	118.38	118.7	118.19	118.47	31966323.0
2010-10-28 16:00:00	SPY	ETF	118.47	118.875	118.055	118.47	9364369.0
2010-10-28 17:00:00	SPY	ETF	118.45	118.52	118.33	118.33	256075.0
2010-10-28 18:00:00	SPY	ETF	118.38	118.44	118.37	118.42	143517.0
2010-10-28 19:00:00	SPY	ETF	118.44	118.44	118.35	118.39	34268.0
2010-10-28 04:00:00	QQQ	ETF	52.25	52.25	52.25	52.25	185.0
2010-10-28 05:00:00	QQQ	ETF	52.35	52.35	52.32	52.32	19175.0
2010-10-28 06:00:00	QQQ	ETF	52.32	52.32	52.25	52.27	5100.0
2010-10-28 07:00:00	QQQ	ETF	52.24	52.26	52.23	52.26	35309.0
2010-10-28 08:00:00	QQQ	ETF	52.25	52.5	52.25	52.4	1035358.0
2010-10-28 09:00:00	QQQ	ETF	52.4	52.45	52.2	52.24	8451846.0
2010-10-28 10:00:00	QQQ	ETF	52.24	52.33	51.94	52.04	13507404.0
2010-10-28 11:00:00	QQQ	ETF	52.035	52.17	52.0	52.01	4638866.0
2010-10-28 12:00:00	QQQ	ETF	52.0	52.0	51.87	51.895	6738855.0
2010-10-28 13:00:00	QQQ	ETF	51.89	52.19	51.84	52.1006	6058166.0
2010-10-28 14:00:00	QQQ	ETF	52.1	52.32	52.08	52.2519	5440159.0
2010-10-28 15:00:00	QQQ	ETF	52.2526	52.39	52.16	52.3	9073353.0
2010-10-28 16:00:00	QQQ	ETF	52.3	52.38	52.2355	52.36	4144202.0
2010-10-28 17:00:00	QQQ	ETF	52.34	52.35	52.3	52.3	40716.0
2010-10-28 18:00:00	QQQ	ETF	52.31	52.31	52.29	52.3	12814.0
2010-10-28 19:00:00	QQQ	ETF	52.3	52.35	52.27	52.35	98188.0
2010-10-28 05:00:00	IWM	ETF	70.73	70.73	70.73	70.73	100.0
2010-10-28 06:00:00	IWM	ETF	70.63	70.63	70.63	70.63	200.0
2010-10-28 07:00:00	IWM	ETF	70.6	70.67	70.57	70.66	2400.0
2010-10-28 08:00:00	IWM	ETF	70.66	71.16	70.51	71.02	497755.0
2010-10-28 09:00:00	IWM	ETF	71.02	71.12	70.59	70.7	5377629.0
2010-10-28 10:00:00	IWM	ETF	70.7	70.8	69.94	70.11	8325868.0
2010-10-28 11:00:00	IWM	ETF	70.11	70.25	69.851	69.88	3697530.0
2010-10-28 12:00:00	IWM	ETF	69.87	70.03	69.75	69.89	4163227.0
2010-10-28 13:00:00	IWM	ETF	69.9	70.26	69.81	70.01	4566961.0
2010-10-28 14:00:00	IWM	ETF	70.01	70.34	69.97	70.24	4152605.0
2010-10-28 15:00:00	IWM	ETF	70.24	70.39	70.05	70.12	7643014.0
2010-10-28 16:00:00	IWM	ETF	70.12	70.7	69.89	70.0	2888803.0
2010-10-28 17:00:00	IWM	ETF	69.99	70.0	69.95	69.99	25820.0
2010-10-28 18:00:00	IWM	ETF	70.04	70.13	69.96	69.97	12769.0
2010-10-28 19:00:00	IWM	ETF	69.98	69.98	69.92	69.92	2900.0
2010-10-28 07:00:00	DIA	ETF	111.42	111.42	111.42	111.42	1010.0
2010-10-28 08:00:00	DIA	ETF	111.44	111.86	111.41	111.74	38712.0
2010-10-28 09:00:00	DIA	ETF	111.77	111.8601	111.52	111.62	602075.0

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

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