PREVIEW / etf_1hour / 2009-09-29

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-09-29.parquet
  size:    141 KB
  rows:    4,321

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-29 04:00:00	SPY	ETF	106.23	106.23	106.14	106.14	300.0
2009-09-29 05:00:00	SPY	ETF	106.18	106.2	106.11	106.2	10500.0
2009-09-29 06:00:00	SPY	ETF	106.21	106.26	106.1	106.17	21500.0
2009-09-29 07:00:00	SPY	ETF	106.16	106.38	106.12	106.19	110317.0
2009-09-29 08:00:00	SPY	ETF	106.18	106.38	106.08	106.36	1665263.0
2009-09-29 09:00:00	SPY	ETF	106.36	107.02	106.03	106.88	21167698.0
2009-09-29 10:00:00	SPY	ETF	106.88	106.938	106.01	106.05	37411222.0
2009-09-29 11:00:00	SPY	ETF	106.05	106.22	105.78	105.96	15580248.0
2009-09-29 12:00:00	SPY	ETF	105.96	106.33	105.95	106.32	10804687.0
2009-09-29 13:00:00	SPY	ETF	106.32	106.53	106.2944	106.5017	10749983.0
2009-09-29 14:00:00	SPY	ETF	106.5	106.52	106.13	106.33	10221419.0
2009-09-29 15:00:00	SPY	ETF	106.34	106.43	106.01	106.02	19776172.0
2009-09-29 16:00:00	SPY	ETF	106.02	106.45	105.88	105.94	3425881.0
2009-09-29 17:00:00	SPY	ETF	105.94	105.99	105.85	105.94	345188.0
2009-09-29 18:00:00	SPY	ETF	105.92	106.03	105.9	105.97	142950.0
2009-09-29 19:00:00	SPY	ETF	105.97	106.04	105.94	106.03	32914.0
2009-09-29 04:00:00	QQQ	ETF	42.34	42.34	42.3	42.3	900.0
2009-09-29 05:00:00	QQQ	ETF	42.25	42.25	42.25	42.25	3000.0
2009-09-29 06:00:00	QQQ	ETF	42.31	42.32	42.24	42.27	25500.0
2009-09-29 07:00:00	QQQ	ETF	42.25	42.32	42.25	42.28	154660.0
2009-09-29 08:00:00	QQQ	ETF	42.27	42.36	42.24	42.36	368145.0
2009-09-29 09:00:00	QQQ	ETF	42.36	42.6201	42.24	42.55	16071372.0
2009-09-29 10:00:00	QQQ	ETF	42.55	42.5651	42.13	42.13	31435302.0
2009-09-29 11:00:00	QQQ	ETF	42.13	42.22	42.03	42.1	7532950.0
2009-09-29 12:00:00	QQQ	ETF	42.09	42.31	42.09	42.31	7685658.0
2009-09-29 13:00:00	QQQ	ETF	42.31	42.41	42.3001	42.35	10933686.0
2009-09-29 14:00:00	QQQ	ETF	42.35	42.35	42.23	42.29	5288266.0
2009-09-29 15:00:00	QQQ	ETF	42.29	42.34	42.2	42.24	18105065.0
2009-09-29 16:00:00	QQQ	ETF	42.24	42.28	42.09	42.22	3339147.0
2009-09-29 17:00:00	QQQ	ETF	42.21	42.25	42.21	42.25	42584.0
2009-09-29 18:00:00	QQQ	ETF	42.24	42.24	42.18	42.22	98400.0
2009-09-29 19:00:00	QQQ	ETF	42.24	42.26	42.23	42.26	7550.0
2009-09-29 04:00:00	IWM	ETF	61.24	61.24	61.08	61.08	900.0
2009-09-29 06:00:00	IWM	ETF	61.16	61.17	61.08	61.08	300.0
2009-09-29 07:00:00	IWM	ETF	61.05	61.25	61.05	61.14	12300.0
2009-09-29 08:00:00	IWM	ETF	61.13	61.27	61.06	61.24	253132.0
2009-09-29 09:00:00	IWM	ETF	61.23	61.78	61.0	61.7	5886037.0
2009-09-29 10:00:00	IWM	ETF	61.69	61.7	61.05	61.13	10569660.0
2009-09-29 11:00:00	IWM	ETF	61.12	61.25	60.92	60.96	2518468.0
2009-09-29 12:00:00	IWM	ETF	60.97	61.34	60.97	61.31	3252319.0
2009-09-29 13:00:00	IWM	ETF	61.3	61.44	61.28	61.4225	2485821.0
2009-09-29 14:00:00	IWM	ETF	61.43	61.44	61.26	61.3	2803078.0
2009-09-29 15:00:00	IWM	ETF	61.29	61.36	61.02	61.03	6325079.0
2009-09-29 16:00:00	IWM	ETF	61.02	61.2465	60.84	60.86	1213928.0
2009-09-29 17:00:00	IWM	ETF	60.87	60.91	60.84	60.91	5810.0
2009-09-29 18:00:00	IWM	ETF	60.93	60.97	60.91	60.91	1000.0
2009-09-29 19:00:00	IWM	ETF	60.93	60.95	60.9	60.92	700.0
2009-09-29 07:00:00	DIA	ETF	97.85	97.85	97.83	97.83	200.0
2009-09-29 08:00:00	DIA	ETF	97.78	97.91	97.7	97.91	19800.0
2009-09-29 09:00:00	DIA	ETF	97.92	98.36	97.84	98.27	1333301.0

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

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