PREVIEW / etf_1hour / 2009-11-17

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-11-17.parquet
  size:    148 KB
  rows:    4,555

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
2009-11-17 04:00:00	SPY	ETF	110.93	111.02	110.93	111.02	700.0
2009-11-17 05:00:00	SPY	ETF	110.96	111.01	110.96	111.01	1800.0
2009-11-17 06:00:00	SPY	ETF	110.95	111.07	110.84	111.07	51700.0
2009-11-17 07:00:00	SPY	ETF	111.04	111.04	110.65	110.86	247613.0
2009-11-17 08:00:00	SPY	ETF	110.58	111.05	110.58	110.95	2433437.0
2009-11-17 09:00:00	SPY	ETF	110.95	111.23	110.74	110.991	22808668.0
2009-11-17 10:00:00	SPY	ETF	111.0	111.15	110.52	110.78	28434385.0
2009-11-17 11:00:00	SPY	ETF	110.779	110.88	110.5	110.7999	15521703.0
2009-11-17 12:00:00	SPY	ETF	110.79	111.17	110.71	111.0	11032768.0
2009-11-17 13:00:00	SPY	ETF	111.0	111.29	110.82	111.16	13101127.0
2009-11-17 14:00:00	SPY	ETF	111.15	111.17	110.89	111.04	15024269.0
2009-11-17 15:00:00	SPY	ETF	111.03	111.39	111.01	111.33	23399992.0
2009-11-17 16:00:00	SPY	ETF	111.34	111.34	110.5451	111.23	9237463.0
2009-11-17 17:00:00	SPY	ETF	111.23	111.26	111.2	111.24	3162745.0
2009-11-17 18:00:00	SPY	ETF	111.24	111.34	111.21	111.34	102825.0
2009-11-17 19:00:00	SPY	ETF	111.33	111.55	111.33	111.51	121600.0
2009-11-17 04:00:00	QQQ	ETF	44.4	44.4	44.4	44.4	300.0
2009-11-17 05:00:00	QQQ	ETF	44.38	44.38	44.38	44.38	1000.0
2009-11-17 06:00:00	QQQ	ETF	44.35	44.4	44.31	44.4	10200.0
2009-11-17 07:00:00	QQQ	ETF	44.37	44.37	44.23	44.3	417097.0
2009-11-17 08:00:00	QQQ	ETF	44.18	44.36	44.18	44.31	1861481.0
2009-11-17 09:00:00	QQQ	ETF	44.32	44.55	44.29	44.46	15401207.0
2009-11-17 10:00:00	QQQ	ETF	44.46	44.5088	44.25	44.33	14985660.0
2009-11-17 11:00:00	QQQ	ETF	44.32	44.39	44.25	44.3818	8266369.0
2009-11-17 12:00:00	QQQ	ETF	44.39	44.51	44.345	44.43	6535267.0
2009-11-17 13:00:00	QQQ	ETF	44.43	44.55	44.38	44.5078	7157131.0
2009-11-17 14:00:00	QQQ	ETF	44.5	44.51	44.4	44.49	7319165.0
2009-11-17 15:00:00	QQQ	ETF	44.49	44.6	44.48	44.6	11398220.0
2009-11-17 16:00:00	QQQ	ETF	44.6	44.61	44.41	44.53	2884441.0
2009-11-17 17:00:00	QQQ	ETF	44.52	44.55	44.52	44.54	10000.0
2009-11-17 18:00:00	QQQ	ETF	44.53	44.59	44.53	44.57	38876.0
2009-11-17 19:00:00	QQQ	ETF	44.57	44.65	44.57	44.64	23433.0
2009-11-17 07:00:00	IWM	ETF	59.9	59.95	59.9	59.9	9500.0
2009-11-17 08:00:00	IWM	ETF	60.03	60.14	59.75	60.06	408119.0
2009-11-17 09:00:00	IWM	ETF	60.07	60.26	59.91	60.04	6811550.0
2009-11-17 10:00:00	IWM	ETF	60.04	60.15	59.74	59.93	8600777.0
2009-11-17 11:00:00	IWM	ETF	59.94	60.14	59.83	60.11	4802636.0
2009-11-17 12:00:00	IWM	ETF	60.11	60.37	60.0	60.23	3421492.0
2009-11-17 13:00:00	IWM	ETF	60.23	60.48	60.08	60.4	3442208.0
2009-11-17 14:00:00	IWM	ETF	60.4025	60.4101	60.23	60.3	3099207.0
2009-11-17 15:00:00	IWM	ETF	60.3	60.43	60.27	60.29	7944682.0
2009-11-17 16:00:00	IWM	ETF	60.3	60.3596	60.14	60.19	4390736.0
2009-11-17 17:00:00	IWM	ETF	60.2	60.22	60.16	60.19	28949.0
2009-11-17 18:00:00	IWM	ETF	60.25	60.26	60.22	60.22	300.0
2009-11-17 19:00:00	IWM	ETF	60.3	60.36	60.3	60.36	2503.0
2009-11-17 07:00:00	DIA	ETF	103.8	103.8	103.8	103.8	100.0
2009-11-17 08:00:00	DIA	ETF	104.0	104.13	103.95	104.05	20970.0
2009-11-17 09:00:00	DIA	ETF	104.08	104.4	103.94	104.19	1734335.0
2009-11-17 10:00:00	DIA	ETF	104.19	104.35	103.89	104.11	1949301.0
2009-11-17 11:00:00	DIA	ETF	104.1	104.17	103.86	104.14	691043.0

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

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