PREVIEW / etf_5min / 2009-06-24

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-06-24.parquet
  size:    672 KB
  rows:    28,628

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-06-24 04:15:00	SPY	ETF	89.62	89.62	89.62	89.62	950.0
2009-06-24 04:20:00	SPY	ETF	89.68	89.68	89.68	89.68	100.0
2009-06-24 04:40:00	SPY	ETF	89.74	89.74	89.74	89.74	400.0
2009-06-24 04:45:00	SPY	ETF	89.7	89.7	89.7	89.7	20000.0
2009-06-24 04:50:00	SPY	ETF	89.62	89.62	89.62	89.62	100.0
2009-06-24 04:55:00	SPY	ETF	89.62	89.62	89.62	89.62	100.0
2009-06-24 05:10:00	SPY	ETF	89.78	89.85	89.78	89.85	400.0
2009-06-24 05:20:00	SPY	ETF	89.87	89.87	89.75	89.75	20100.0
2009-06-24 05:50:00	SPY	ETF	89.94	89.94	89.94	89.94	800.0
2009-06-24 06:05:00	SPY	ETF	89.83	89.83	89.83	89.83	100.0
2009-06-24 06:10:00	SPY	ETF	89.81	89.81	89.81	89.81	100.0
2009-06-24 06:15:00	SPY	ETF	89.84	89.84	89.84	89.84	100.0
2009-06-24 06:20:00	SPY	ETF	89.82	89.9	89.82	89.9	700.0
2009-06-24 06:35:00	SPY	ETF	89.87	89.87	89.87	89.87	2200.0
2009-06-24 06:40:00	SPY	ETF	89.8	89.82	89.78	89.82	8800.0
2009-06-24 06:45:00	SPY	ETF	89.81	89.81	89.77	89.77	2625.0
2009-06-24 06:50:00	SPY	ETF	89.74	89.79	89.74	89.79	9200.0
2009-06-24 06:55:00	SPY	ETF	89.81	89.84	89.8	89.84	1600.0
2009-06-24 07:00:00	SPY	ETF	89.84	89.86	89.84	89.85	14600.0
2009-06-24 07:05:00	SPY	ETF	89.86	89.86	89.85	89.86	7100.0
2009-06-24 07:10:00	SPY	ETF	89.86	89.9	89.8	89.89	32298.0
2009-06-24 07:15:00	SPY	ETF	89.88	89.88	89.86	89.87	3880.0
2009-06-24 07:20:00	SPY	ETF	89.87	90.08	89.87	90.07	84866.0
2009-06-24 07:25:00	SPY	ETF	90.07	90.09	89.91	89.91	113856.0
2009-06-24 07:30:00	SPY	ETF	89.91	89.91	89.76	89.84	43800.0
2009-06-24 07:35:00	SPY	ETF	89.83	89.91	89.83	89.9	13551.0
2009-06-24 07:40:00	SPY	ETF	89.9	89.9	89.82	89.84	17160.0
2009-06-24 07:45:00	SPY	ETF	89.86	89.87	89.81	89.81	19977.0
2009-06-24 07:50:00	SPY	ETF	89.83	89.88	89.83	89.87	18799.0
2009-06-24 07:55:00	SPY	ETF	89.88	89.94	89.88	89.91	120158.0
2009-06-24 08:00:00	SPY	ETF	89.9	89.95	89.81	89.91	997581.0
2009-06-24 08:05:00	SPY	ETF	89.9	89.95	89.84	89.91	112367.0
2009-06-24 08:10:00	SPY	ETF	89.91	89.91	89.84	89.88	17548.0
2009-06-24 08:15:00	SPY	ETF	89.87	89.91	89.87	89.91	51431.0
2009-06-24 08:20:00	SPY	ETF	89.92	89.92	89.84	89.9	363027.0
2009-06-24 08:25:00	SPY	ETF	89.9	89.96	89.83	89.92	189842.0
2009-06-24 08:30:00	SPY	ETF	89.96	90.36	89.9	90.28	2581467.0
2009-06-24 08:35:00	SPY	ETF	90.28	90.44	90.25	90.32	949366.0
2009-06-24 08:40:00	SPY	ETF	90.32	90.32	90.23	90.26	473248.0
2009-06-24 08:45:00	SPY	ETF	90.25	90.37	90.24	90.31	246030.0
2009-06-24 08:50:00	SPY	ETF	90.32	90.35	89.36	90.29	328104.0
2009-06-24 08:55:00	SPY	ETF	90.28	90.31	90.25	90.26	133285.0
2009-06-24 09:00:00	SPY	ETF	90.26	90.3	90.25	90.25	233067.0
2009-06-24 09:05:00	SPY	ETF	90.25	90.26	90.13	90.21	289533.0
2009-06-24 09:10:00	SPY	ETF	90.2	90.23	90.16	90.21	93791.0
2009-06-24 09:15:00	SPY	ETF	90.21	90.23	90.13	90.16	62735.0
2009-06-24 09:20:00	SPY	ETF	90.16	90.17	90.12	90.12	156323.0
2009-06-24 09:25:00	SPY	ETF	90.14	90.19	90.1	90.15	296437.0
2009-06-24 09:30:00	SPY	ETF	90.16	90.19	90.04	90.05	2414030.0
2009-06-24 09:35:00	SPY	ETF	90.05	90.29	90.04	90.2	3329782.0

> showing 50 of 28,628 rows — these rows as CSV

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