PREVIEW / etf_5min / 2009-09-09

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-09-09.parquet
  size:    738 KB
  rows:    30,897

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:15:00	SPY	ETF	102.45	102.49	102.45	102.49	1400.0
2009-09-09 04:20:00	SPY	ETF	102.44	102.44	102.44	102.44	100.0
2009-09-09 04:25:00	SPY	ETF	102.44	102.44	102.44	102.44	100.0
2009-09-09 04:45:00	SPY	ETF	102.48	102.56	102.48	102.56	400.0
2009-09-09 05:00:00	SPY	ETF	102.66	102.66	102.66	102.66	1061.0
2009-09-09 05:10:00	SPY	ETF	102.68	102.68	102.68	102.68	3000.0
2009-09-09 05:20:00	SPY	ETF	102.66	102.66	102.66	102.66	100.0
2009-09-09 05:45:00	SPY	ETF	102.76	102.76	102.76	102.76	1000.0
2009-09-09 05:50:00	SPY	ETF	102.86	102.86	102.86	102.86	100.0
2009-09-09 05:55:00	SPY	ETF	102.9	102.95	102.9	102.94	4600.0
2009-09-09 06:05:00	SPY	ETF	103.0	103.0	103.0	103.0	798.0
2009-09-09 06:10:00	SPY	ETF	102.93	102.93	102.93	102.93	200.0
2009-09-09 06:20:00	SPY	ETF	102.91	102.91	102.91	102.91	200.0
2009-09-09 06:25:00	SPY	ETF	102.88	102.88	102.88	102.88	100.0
2009-09-09 06:30:00	SPY	ETF	102.9	102.9	102.9	102.9	200.0
2009-09-09 06:35:00	SPY	ETF	102.88	102.88	102.83	102.83	600.0
2009-09-09 06:55:00	SPY	ETF	102.81	102.81	102.81	102.81	25000.0
2009-09-09 07:00:00	SPY	ETF	102.88	102.89	102.88	102.89	200.0
2009-09-09 07:05:00	SPY	ETF	102.88	102.98	102.86	102.98	16100.0
2009-09-09 07:10:00	SPY	ETF	102.96	102.96	102.95	102.95	49200.0
2009-09-09 07:15:00	SPY	ETF	102.94	102.97	102.94	102.97	27100.0
2009-09-09 07:20:00	SPY	ETF	102.96	102.97	102.96	102.97	16400.0
2009-09-09 07:25:00	SPY	ETF	102.94	102.94	102.92	102.92	6800.0
2009-09-09 07:35:00	SPY	ETF	102.95	103.07	102.95	103.07	90627.0
2009-09-09 07:40:00	SPY	ETF	103.04	103.07	103.01	103.07	42600.0
2009-09-09 07:45:00	SPY	ETF	103.07	103.08	103.04	103.08	13650.0
2009-09-09 07:50:00	SPY	ETF	103.1	103.14	103.09	103.09	10183.0
2009-09-09 07:55:00	SPY	ETF	103.07	103.07	103.01	103.05	152407.0
2009-09-09 08:00:00	SPY	ETF	103.01	103.06	102.96	102.96	107213.0
2009-09-09 08:05:00	SPY	ETF	102.96	103.05	102.95	103.01	147294.0
2009-09-09 08:10:00	SPY	ETF	103.01	103.07	103.01	103.04	42483.0
2009-09-09 08:15:00	SPY	ETF	103.04	103.17	103.04	103.16	132143.0
2009-09-09 08:20:00	SPY	ETF	103.16	103.3	103.16	103.25	349814.0
2009-09-09 08:25:00	SPY	ETF	103.25	103.27	103.22	103.27	90713.0
2009-09-09 08:30:00	SPY	ETF	103.28	103.28	103.19	103.2	111003.0
2009-09-09 08:35:00	SPY	ETF	103.2	103.26	102.89	103.15	315181.0
2009-09-09 08:40:00	SPY	ETF	103.16	103.16	103.12	103.13	84811.0
2009-09-09 08:45:00	SPY	ETF	103.13	103.15	103.09	103.1	276433.0
2009-09-09 08:50:00	SPY	ETF	103.1	103.11	103.05	103.05	161180.0
2009-09-09 08:55:00	SPY	ETF	103.05	103.08	103.05	103.05	55976.0
2009-09-09 09:00:00	SPY	ETF	103.04	103.1	103.04	103.07	76612.0
2009-09-09 09:05:00	SPY	ETF	103.06	103.1	103.06	103.06	89745.0
2009-09-09 09:10:00	SPY	ETF	103.06	103.15	103.0	103.14	204316.0
2009-09-09 09:15:00	SPY	ETF	103.13	103.14	103.11	103.11	24320.0
2009-09-09 09:20:00	SPY	ETF	103.1	103.14	103.1	103.11	66964.0
2009-09-09 09:25:00	SPY	ETF	103.12	103.12	103.06	103.11	118886.0
2009-09-09 09:30:00	SPY	ETF	103.12	103.2	102.81	102.85	5302081.0
2009-09-09 09:35:00	SPY	ETF	102.84	103.12	102.82	102.85	4371721.0
2009-09-09 09:40:00	SPY	ETF	102.86	102.95	102.8	102.94	2327465.0
2009-09-09 09:45:00	SPY	ETF	102.94	103.22	102.94	103.14	3611571.0

> showing 50 of 30,897 rows — these rows as CSV

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