PREVIEW / etf_1hour / 2009-07-10

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-10.parquet
  size:    131 KB
  rows:    4,042

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-07-10 04:00:00	SPY	ETF	88.19	88.2	88.13	88.2	1500.0
2009-07-10 05:00:00	SPY	ETF	87.96	87.96	87.88	87.88	4200.0
2009-07-10 06:00:00	SPY	ETF	87.78	87.84	87.64	87.71	13000.0
2009-07-10 07:00:00	SPY	ETF	87.66	87.78	87.56	87.62	463520.0
2009-07-10 08:00:00	SPY	ETF	87.62	87.8	87.52	87.7	2335561.0
2009-07-10 09:00:00	SPY	ETF	87.7	88.49	87.61	88.0	30249378.0
2009-07-10 10:00:00	SPY	ETF	87.99	88.35	87.64	88.01	28725547.0
2009-07-10 11:00:00	SPY	ETF	88.0	88.01	87.35	87.54	23199528.0
2009-07-10 12:00:00	SPY	ETF	87.54	88.3532	87.5	87.86	18087682.0
2009-07-10 13:00:00	SPY	ETF	87.8699	88.3532	87.81	88.0502	15018929.0
2009-07-10 14:00:00	SPY	ETF	88.06	88.06	87.67	87.74	15399746.0
2009-07-10 15:00:00	SPY	ETF	87.74	88.22	87.7	87.94	29703244.0
2009-07-10 16:00:00	SPY	ETF	87.92	88.3532	87.76	87.82	9514571.0
2009-07-10 17:00:00	SPY	ETF	87.83	88.0	87.79	87.85	143505.0
2009-07-10 18:00:00	SPY	ETF	87.85	87.88	87.6422	87.87	32795.0
2009-07-10 19:00:00	SPY	ETF	87.86	87.88	87.8	87.86	31058.0
2009-07-10 05:00:00	QQQ	ETF	34.68	34.68	34.65	34.65	2300.0
2009-07-10 06:00:00	QQQ	ETF	34.63	34.65	34.6	34.6	2100.0
2009-07-10 07:00:00	QQQ	ETF	34.61	34.68	34.6	34.62	719829.0
2009-07-10 08:00:00	QQQ	ETF	34.61	34.67	34.5	34.65	838610.0
2009-07-10 09:00:00	QQQ	ETF	34.65	35.14	34.62	35.0	22493807.0
2009-07-10 10:00:00	QQQ	ETF	35.0	35.1	34.85	34.94	18656172.0
2009-07-10 11:00:00	QQQ	ETF	34.95	34.95	34.5626	34.75	16277793.0
2009-07-10 12:00:00	QQQ	ETF	34.74	34.9	34.65	34.84	7752294.0
2009-07-10 13:00:00	QQQ	ETF	34.84	34.98	34.8	34.92	10024127.0
2009-07-10 14:00:00	QQQ	ETF	34.93	34.93	34.79	34.83	7333661.0
2009-07-10 15:00:00	QQQ	ETF	34.84	34.98	34.82	34.92	16031465.0
2009-07-10 16:00:00	QQQ	ETF	34.92	34.97	34.62	34.9	4464587.0
2009-07-10 17:00:00	QQQ	ETF	34.92	34.94	34.86	34.92	33115.0
2009-07-10 18:00:00	QQQ	ETF	34.92	34.92	34.87	34.89	15903.0
2009-07-10 19:00:00	QQQ	ETF	34.89	34.92	34.89	34.9	2100.0
2009-07-10 07:00:00	IWM	ETF	47.64	47.67	47.49	47.5	21100.0
2009-07-10 08:00:00	IWM	ETF	47.53	47.6	47.37	47.51	127647.0
2009-07-10 09:00:00	IWM	ETF	47.47	48.27	47.46	47.92	6118038.0
2009-07-10 10:00:00	IWM	ETF	47.9197	48.19	47.4975	47.92	6912768.0
2009-07-10 11:00:00	IWM	ETF	47.91	47.91	47.33	47.55	6692938.0
2009-07-10 12:00:00	IWM	ETF	47.55	47.94	47.52	47.89	3392790.0
2009-07-10 13:00:00	IWM	ETF	47.9	48.0722	47.86	48.01	3177500.0
2009-07-10 14:00:00	IWM	ETF	48.01	48.02	47.82	47.882	3077603.0
2009-07-10 15:00:00	IWM	ETF	47.8899	48.18	47.87	48.1	9047827.0
2009-07-10 16:00:00	IWM	ETF	48.09	48.14	47.4	48.03	862929.0
2009-07-10 17:00:00	IWM	ETF	48.04	48.05	48.02	48.04	1927.0
2009-07-10 19:00:00	IWM	ETF	48.07	48.07	48.05	48.05	500.0
2009-07-10 06:00:00	DIA	ETF	81.33	81.33	81.3	81.3	500.0
2009-07-10 07:00:00	DIA	ETF	81.33	81.36	81.18	81.28	2300.0
2009-07-10 08:00:00	DIA	ETF	81.26	81.44	81.22	81.38	29799.0
2009-07-10 09:00:00	DIA	ETF	81.38	81.94	81.29	81.5601	1940315.0
2009-07-10 10:00:00	DIA	ETF	81.56	81.878	81.34	81.46	2779257.0
2009-07-10 11:00:00	DIA	ETF	81.4597	81.46	81.02	81.1794	1372931.0
2009-07-10 12:00:00	DIA	ETF	81.17	81.53	81.16	81.4	601607.0

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

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