PREVIEW / etf_5min / 2008-07-24

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-07-24.parquet
  size:    535 KB
  rows:    24,740

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-24 05:15:00	SPY	ETF	128.09	128.09	128.09	128.09	100.0
2008-07-24 05:50:00	SPY	ETF	127.82	127.82	127.82	127.82	200.0
2008-07-24 05:55:00	SPY	ETF	127.84	127.84	127.84	127.84	1100.0
2008-07-24 06:05:00	SPY	ETF	127.8	127.8	127.8	127.8	200.0
2008-07-24 06:10:00	SPY	ETF	127.98	127.98	127.9	127.9	35000.0
2008-07-24 06:15:00	SPY	ETF	127.91	127.91	127.91	127.91	100.0
2008-07-24 06:30:00	SPY	ETF	127.91	127.91	127.87	127.87	45000.0
2008-07-24 06:35:00	SPY	ETF	127.88	127.88	127.85	127.85	30200.0
2008-07-24 06:40:00	SPY	ETF	127.88	127.88	127.81	127.81	62000.0
2008-07-24 06:45:00	SPY	ETF	127.8	127.86	127.8	127.86	10100.0
2008-07-24 06:50:00	SPY	ETF	127.82	127.88	127.82	127.88	4200.0
2008-07-24 06:55:00	SPY	ETF	127.88	127.88	127.88	127.88	1000.0
2008-07-24 07:00:00	SPY	ETF	127.87	127.92	127.73	127.78	86500.0
2008-07-24 07:05:00	SPY	ETF	127.76	127.78	127.7	127.78	19235.0
2008-07-24 07:10:00	SPY	ETF	127.72	127.87	127.7	127.87	4300.0
2008-07-24 07:15:00	SPY	ETF	127.85	127.86	127.84	127.84	51200.0
2008-07-24 07:20:00	SPY	ETF	127.76	127.78	127.72	127.72	28600.0
2008-07-24 07:25:00	SPY	ETF	127.72	127.72	127.62	127.71	22500.0
2008-07-24 07:30:00	SPY	ETF	127.71	127.77	127.71	127.74	50600.0
2008-07-24 07:35:00	SPY	ETF	127.75	127.86	127.73	127.86	13300.0
2008-07-24 07:40:00	SPY	ETF	127.84	127.98	127.84	127.91	272349.0
2008-07-24 07:45:00	SPY	ETF	127.92	128.01	127.92	127.95	133208.0
2008-07-24 07:50:00	SPY	ETF	127.94	128.08	127.92	128.07	303100.0
2008-07-24 07:55:00	SPY	ETF	128.04	128.05	127.97	127.98	26810.0
2008-07-24 08:00:00	SPY	ETF	127.98	128.04	127.98	127.98	14745.0
2008-07-24 08:05:00	SPY	ETF	127.97	128.0	127.95	127.95	24935.0
2008-07-24 08:10:00	SPY	ETF	127.95	128.0	127.95	128.0	8500.0
2008-07-24 08:15:00	SPY	ETF	128.0	128.02	127.79	127.94	200027.0
2008-07-24 08:20:00	SPY	ETF	127.96	128.02	127.92	127.95	182563.0
2008-07-24 08:25:00	SPY	ETF	127.96	128.12	127.92	128.01	180336.0
2008-07-24 08:30:00	SPY	ETF	127.98	128.0	127.74	127.94	1596646.0
2008-07-24 08:35:00	SPY	ETF	127.92	128.04	127.9	127.99	384483.0
2008-07-24 08:40:00	SPY	ETF	127.99	128.02	127.92	127.97	95082.0
2008-07-24 08:45:00	SPY	ETF	128.0	128.02	127.96	127.97	97394.0
2008-07-24 08:50:00	SPY	ETF	127.97	128.01	127.94	127.97	63800.0
2008-07-24 08:55:00	SPY	ETF	127.97	128.04	127.96	128.04	166512.0
2008-07-24 09:00:00	SPY	ETF	128.05	128.14	128.01	128.11	161109.0
2008-07-24 09:05:00	SPY	ETF	128.1	128.12	128.03	128.11	96308.0
2008-07-24 09:10:00	SPY	ETF	128.11	128.22	128.06	128.19	174062.0
2008-07-24 09:15:00	SPY	ETF	128.19	128.27	128.16	128.27	231202.0
2008-07-24 09:20:00	SPY	ETF	128.26	128.41	128.26	128.34	387972.0
2008-07-24 09:25:00	SPY	ETF	128.34	128.35	128.28	128.34	350311.0
2008-07-24 09:30:00	SPY	ETF	128.34	128.41	128.0	128.01	3294067.0
2008-07-24 09:35:00	SPY	ETF	128.01	128.07	127.87	127.92	4177654.0
2008-07-24 09:40:00	SPY	ETF	127.93	127.97	127.78	127.93	3708417.0
2008-07-24 09:45:00	SPY	ETF	127.94	128.07	127.78	127.818	3331442.0
2008-07-24 09:50:00	SPY	ETF	127.82	127.94	127.6	127.65	3957369.0
2008-07-24 09:55:00	SPY	ETF	127.65	127.8	127.57	127.7201	5830940.0
2008-07-24 10:00:00	SPY	ETF	127.72	127.72	127.38	127.5	8141365.0
2008-07-24 10:05:00	SPY	ETF	127.515	127.52	127.16	127.21	3840606.0

> showing 50 of 24,740 rows — these rows as CSV

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