PREVIEW / etf_5min / 2008-07-29

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-07-29.parquet
  size:    483 KB
  rows:    22,853

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
2008-07-29 04:15:00	SPY	ETF	123.84	123.84	123.84	123.84	100.0
2008-07-29 05:20:00	SPY	ETF	123.92	123.92	123.92	123.92	100.0
2008-07-29 06:00:00	SPY	ETF	123.28	123.28	123.28	123.28	1000.0
2008-07-29 06:25:00	SPY	ETF	123.56	123.56	123.56	123.56	1000.0
2008-07-29 06:35:00	SPY	ETF	123.49	123.49	123.49	123.49	100.0
2008-07-29 06:45:00	SPY	ETF	123.58	123.58	123.55	123.55	25000.0
2008-07-29 07:00:00	SPY	ETF	123.74	123.75	123.68	123.71	74870.0
2008-07-29 07:05:00	SPY	ETF	123.67	123.89	123.67	123.89	32900.0
2008-07-29 07:10:00	SPY	ETF	123.92	124.02	123.84	124.0	184700.0
2008-07-29 07:15:00	SPY	ETF	124.0	124.08	124.0	124.02	128839.0
2008-07-29 07:20:00	SPY	ETF	124.07	124.07	123.8	123.81	195739.0
2008-07-29 07:25:00	SPY	ETF	123.86	123.99	123.86	123.88	10600.0
2008-07-29 07:30:00	SPY	ETF	123.88	124.15	123.88	124.02	444623.0
2008-07-29 07:35:00	SPY	ETF	124.03	124.06	123.91	123.92	235332.0
2008-07-29 07:40:00	SPY	ETF	123.92	123.94	123.91	123.91	19400.0
2008-07-29 07:45:00	SPY	ETF	123.92	124.03	123.91	124.03	101099.0
2008-07-29 07:50:00	SPY	ETF	124.03	124.15	124.03	124.15	62217.0
2008-07-29 07:55:00	SPY	ETF	124.13	124.2	124.13	124.17	61200.0
2008-07-29 08:00:00	SPY	ETF	124.17	124.29	123.51	124.25	282231.0
2008-07-29 08:05:00	SPY	ETF	124.25	124.26	124.15	124.15	52290.0
2008-07-29 08:10:00	SPY	ETF	124.17	124.22	124.09	124.21	170240.0
2008-07-29 08:15:00	SPY	ETF	124.22	124.22	124.17	124.19	366050.0
2008-07-29 08:20:00	SPY	ETF	124.19	124.2	124.0	124.0	104200.0
2008-07-29 08:25:00	SPY	ETF	124.02	124.15	123.99	124.09	206049.0
2008-07-29 08:30:00	SPY	ETF	124.09	124.15	124.07	124.12	114293.0
2008-07-29 08:35:00	SPY	ETF	124.13	124.15	124.09	124.11	60208.0
2008-07-29 08:40:00	SPY	ETF	124.12	124.14	124.02	124.04	136902.0
2008-07-29 08:45:00	SPY	ETF	124.04	124.07	124.03	124.04	36042.0
2008-07-29 08:50:00	SPY	ETF	124.06	124.12	124.05	124.06	335042.0
2008-07-29 08:55:00	SPY	ETF	124.06	124.09	124.05	124.05	123036.0
2008-07-29 09:00:00	SPY	ETF	124.05	124.09	124.02	124.07	245899.0
2008-07-29 09:05:00	SPY	ETF	124.06	124.09	124.02	124.07	147574.0
2008-07-29 09:10:00	SPY	ETF	124.07	124.09	124.03	124.07	122148.0
2008-07-29 09:15:00	SPY	ETF	124.06	124.06	123.86	123.94	283687.0
2008-07-29 09:20:00	SPY	ETF	123.95	123.96	123.86	123.9	239736.0
2008-07-29 09:25:00	SPY	ETF	123.9	124.01	123.89	123.99	275364.0
2008-07-29 09:30:00	SPY	ETF	123.98	124.25	123.97	124.17	3748319.0
2008-07-29 09:35:00	SPY	ETF	124.18	124.27	123.86	123.8799	5542190.0
2008-07-29 09:40:00	SPY	ETF	123.88	124.2	123.84	123.97	5564413.0
2008-07-29 09:45:00	SPY	ETF	123.97	124.12	123.85	123.92	3485687.0
2008-07-29 09:50:00	SPY	ETF	123.93	124.29	123.87	124.22	3914600.0
2008-07-29 09:55:00	SPY	ETF	124.22	124.5	124.18	124.49	5033356.0
2008-07-29 10:00:00	SPY	ETF	124.49	124.71	124.43	124.71	9424176.0
2008-07-29 10:05:00	SPY	ETF	124.72	124.97	124.64	124.88	10046687.0
2008-07-29 10:10:00	SPY	ETF	124.87	124.97	124.78	124.78	6251370.0
2008-07-29 10:15:00	SPY	ETF	124.78	124.96	124.78	124.87	3585370.0
2008-07-29 10:20:00	SPY	ETF	124.86	124.97	124.7	124.86	3373967.0
2008-07-29 10:25:00	SPY	ETF	124.85	124.89	124.75	124.77	3563808.0
2008-07-29 10:30:00	SPY	ETF	124.77	124.91	124.77	124.81	4159695.0
2008-07-29 10:35:00	SPY	ETF	124.81	124.95	124.79	124.89	2599854.0

> showing 50 of 22,853 rows — these rows as CSV

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