PREVIEW / etf_5min / 2008-07-23

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-07-23.parquet
  size:    538 KB
  rows:    25,099

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-23 04:15:00	SPY	ETF	127.97	127.97	127.97	127.97	1000.0
2008-07-23 04:45:00	SPY	ETF	128.22	128.22	128.21	128.21	42000.0
2008-07-23 04:50:00	SPY	ETF	128.21	128.25	128.21	128.25	105100.0
2008-07-23 05:50:00	SPY	ETF	128.13	128.14	128.13	128.14	5000.0
2008-07-23 05:55:00	SPY	ETF	128.15	128.15	128.15	128.15	3000.0
2008-07-23 06:10:00	SPY	ETF	128.2	128.25	128.19	128.19	37000.0
2008-07-23 06:15:00	SPY	ETF	128.19	128.19	128.14	128.14	37600.0
2008-07-23 06:20:00	SPY	ETF	128.16	128.19	128.16	128.19	5000.0
2008-07-23 06:25:00	SPY	ETF	128.16	128.19	128.11	128.18	27800.0
2008-07-23 06:30:00	SPY	ETF	128.14	128.2	128.14	128.16	3100.0
2008-07-23 06:35:00	SPY	ETF	128.14	128.18	128.04	128.04	7700.0
2008-07-23 06:40:00	SPY	ETF	128.1	128.17	128.1	128.17	25000.0
2008-07-23 06:45:00	SPY	ETF	128.11	128.13	128.11	128.13	5200.0
2008-07-23 06:50:00	SPY	ETF	128.05	128.09	128.05	128.09	700.0
2008-07-23 06:55:00	SPY	ETF	128.09	128.13	128.05	128.08	8600.0
2008-07-23 07:00:00	SPY	ETF	127.99	128.11	127.99	128.08	129468.0
2008-07-23 07:05:00	SPY	ETF	128.08	128.08	128.02	128.06	18291.0
2008-07-23 07:10:00	SPY	ETF	128.03	128.05	127.99	128.05	100108.0
2008-07-23 07:15:00	SPY	ETF	128.05	128.12	128.01	128.12	129167.0
2008-07-23 07:20:00	SPY	ETF	128.13	128.16	128.12	128.13	199079.0
2008-07-23 07:25:00	SPY	ETF	128.13	128.18	128.09	128.18	18884.0
2008-07-23 07:30:00	SPY	ETF	128.18	128.18	128.05	128.08	20410.0
2008-07-23 07:35:00	SPY	ETF	128.1	128.11	128.05	128.11	16400.0
2008-07-23 07:40:00	SPY	ETF	128.1	128.1	128.01	128.03	104433.0
2008-07-23 07:45:00	SPY	ETF	128.03	128.03	127.88	127.89	178799.0
2008-07-23 07:50:00	SPY	ETF	127.9	127.95	127.88	127.94	59508.0
2008-07-23 07:55:00	SPY	ETF	127.95	128.1	127.95	128.1	200301.0
2008-07-23 08:00:00	SPY	ETF	128.07	128.16	127.94	128.04	336262.0
2008-07-23 08:05:00	SPY	ETF	128.07	128.11	128.01	128.07	219595.0
2008-07-23 08:10:00	SPY	ETF	128.06	128.13	128.01	128.09	381865.0
2008-07-23 08:15:00	SPY	ETF	128.08	128.23	128.05	128.23	262011.0
2008-07-23 08:20:00	SPY	ETF	128.24	128.26	128.17	128.18	128904.0
2008-07-23 08:25:00	SPY	ETF	128.19	128.28	128.17	128.23	217907.0
2008-07-23 08:30:00	SPY	ETF	128.19	128.25	128.12	128.15	161945.0
2008-07-23 08:35:00	SPY	ETF	128.15	128.21	128.12	128.12	332681.0
2008-07-23 08:40:00	SPY	ETF	128.13	128.14	128.08	128.11	132935.0
2008-07-23 08:45:00	SPY	ETF	128.09	128.12	128.05	128.05	114026.0
2008-07-23 08:50:00	SPY	ETF	128.05	128.07	127.99	127.99	457673.0
2008-07-23 08:55:00	SPY	ETF	127.99	128.04	127.97	128.02	353257.0
2008-07-23 09:00:00	SPY	ETF	128.03	128.15	127.97	128.08	1078171.0
2008-07-23 09:05:00	SPY	ETF	128.07	128.07	127.96	128.03	698531.0
2008-07-23 09:10:00	SPY	ETF	128.02	128.04	127.98	128.02	130274.0
2008-07-23 09:15:00	SPY	ETF	128.0	128.25	127.9	127.92	240298.0
2008-07-23 09:20:00	SPY	ETF	127.92	127.94	127.55	127.85	519947.0
2008-07-23 09:25:00	SPY	ETF	127.85	127.91	127.82	127.9	517680.0
2008-07-23 09:30:00	SPY	ETF	127.89	128.01	127.7	127.73	5289791.0
2008-07-23 09:35:00	SPY	ETF	127.74	127.8	127.66	127.75	5591479.0
2008-07-23 09:40:00	SPY	ETF	127.75	127.81	127.55	127.76	5330231.0
2008-07-23 09:45:00	SPY	ETF	127.76	128.15	127.76	127.97	8013896.0
2008-07-23 09:50:00	SPY	ETF	127.96	128.01	127.75	127.81	3671008.0

> showing 50 of 25,099 rows — these rows as CSV

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