PREVIEW / etf_1hour / 2009-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-09.parquet
  size:    144 KB
  rows:    4,393

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-09-09 04:00:00	SPY	ETF	102.45	102.56	102.44	102.56	2000.0
2009-09-09 05:00:00	SPY	ETF	102.66	102.95	102.66	102.94	9861.0
2009-09-09 06:00:00	SPY	ETF	103.0	103.0	102.81	102.81	27098.0
2009-09-09 07:00:00	SPY	ETF	102.88	103.14	102.86	103.05	425267.0
2009-09-09 08:00:00	SPY	ETF	103.01	103.3	102.89	103.05	1874244.0
2009-09-09 09:00:00	SPY	ETF	103.04	103.43	102.8	103.23	21461044.0
2009-09-09 10:00:00	SPY	ETF	103.225	103.5	103.22	103.36	17883023.0
2009-09-09 11:00:00	SPY	ETF	103.3601	104.0	103.36	103.81	20694791.0
2009-09-09 12:00:00	SPY	ETF	103.819	103.95	103.77	103.95	8465502.0
2009-09-09 13:00:00	SPY	ETF	103.94	104.08	103.78	103.82	16253460.0
2009-09-09 14:00:00	SPY	ETF	103.82	103.92	103.18	103.33	28602524.0
2009-09-09 15:00:00	SPY	ETF	103.34	103.91	103.28	103.76	29070785.0
2009-09-09 16:00:00	SPY	ETF	103.76	103.85	102.9784	103.69	9265452.0
2009-09-09 17:00:00	SPY	ETF	103.69	103.73	103.6	103.61	225352.0
2009-09-09 18:00:00	SPY	ETF	103.63	103.76	103.59	103.63	65065.0
2009-09-09 19:00:00	SPY	ETF	103.63	103.65	103.6	103.6	29692.0
2009-09-09 04:00:00	QQQ	ETF	40.53	40.53	40.53	40.53	645.0
2009-09-09 06:00:00	QQQ	ETF	40.67	40.67	40.65	40.65	700.0
2009-09-09 07:00:00	QQQ	ETF	40.67	40.76	40.67	40.73	36286.0
2009-09-09 08:00:00	QQQ	ETF	40.72	40.82	40.69	40.71	236045.0
2009-09-09 09:00:00	QQQ	ETF	40.72	40.92	40.59	40.84	12624814.0
2009-09-09 10:00:00	QQQ	ETF	40.84	41.02	40.84	40.98	13420792.0
2009-09-09 11:00:00	QQQ	ETF	40.98	41.29	40.98	41.22	12470765.0
2009-09-09 12:00:00	QQQ	ETF	41.22	41.24	41.16	41.2301	6639653.0
2009-09-09 13:00:00	QQQ	ETF	41.2399	41.27	41.13	41.15	9896423.0
2009-09-09 14:00:00	QQQ	ETF	41.15	41.2	40.84	40.92	15247436.0
2009-09-09 15:00:00	QQQ	ETF	40.9296	41.1899	40.91	41.09	17044707.0
2009-09-09 16:00:00	QQQ	ETF	41.09	41.18	40.7504	41.06	6767770.0
2009-09-09 17:00:00	QQQ	ETF	41.05	41.06	40.99	41.03	137459.0
2009-09-09 18:00:00	QQQ	ETF	41.02	41.1	41.02	41.02	59367.0
2009-09-09 19:00:00	QQQ	ETF	41.01	41.03	41.01	41.03	7673.0
2009-09-09 07:00:00	IWM	ETF	57.59	57.75	57.59	57.75	2510.0
2009-09-09 08:00:00	IWM	ETF	57.24	57.81	57.24	57.64	105615.0
2009-09-09 09:00:00	IWM	ETF	57.64	58.01	57.52	57.87	5180139.0
2009-09-09 10:00:00	IWM	ETF	57.86	58.27	57.86	58.21	3879583.0
2009-09-09 11:00:00	IWM	ETF	58.23	58.86	58.22	58.66	5205065.0
2009-09-09 12:00:00	IWM	ETF	58.67	58.87	58.62	58.85	1934296.0
2009-09-09 13:00:00	IWM	ETF	58.8501	59.03	58.72	58.83	3726487.0
2009-09-09 14:00:00	IWM	ETF	58.83	58.9	58.28	58.43	6513721.0
2009-09-09 15:00:00	IWM	ETF	58.44	58.83	58.4	58.64	6621255.0
2009-09-09 16:00:00	IWM	ETF	58.65	58.74	57.7144	58.63	2599336.0
2009-09-09 17:00:00	IWM	ETF	58.63	58.65	58.62	58.65	1897.0
2009-09-09 18:00:00	IWM	ETF	58.71	58.75	58.62	58.62	2328.0
2009-09-09 19:00:00	IWM	ETF	58.62	58.68	58.61	58.68	2100.0
2009-09-09 04:00:00	DIA	ETF	94.55	94.72	94.55	94.72	200.0
2009-09-09 07:00:00	DIA	ETF	95.17	95.19	95.17	95.19	1000.0
2009-09-09 08:00:00	DIA	ETF	95.11	95.27	95.03	95.11	121560.0
2009-09-09 09:00:00	DIA	ETF	95.1	95.46	94.87	95.28	1685468.0
2009-09-09 10:00:00	DIA	ETF	95.28	95.53	95.26	95.35	1636863.0
2009-09-09 11:00:00	DIA	ETF	95.34	95.89	95.34	95.73	1552811.0

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

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