PREVIEW / etf_5min / 2007-08-22

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-08-22.parquet
  size:    360 KB
  rows:    18,335

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
2007-08-22 04:15:00	SPY	ETF	145.79	145.79	145.79	145.79	800.0
2007-08-22 04:20:00	SPY	ETF	145.87	146.08	145.87	146.08	3900.0
2007-08-22 04:25:00	SPY	ETF	146.03	146.03	146.03	146.03	1500.0
2007-08-22 04:35:00	SPY	ETF	145.98	145.98	145.98	145.98	300.0
2007-08-22 04:40:00	SPY	ETF	145.96	145.96	145.96	145.96	300.0
2007-08-22 06:30:00	SPY	ETF	146.03	146.03	146.03	146.03	5000.0
2007-08-22 06:35:00	SPY	ETF	146.11	146.11	146.11	146.11	1500.0
2007-08-22 06:40:00	SPY	ETF	146.12	146.12	146.12	146.12	500.0
2007-08-22 06:45:00	SPY	ETF	146.1	146.1	146.1	146.1	2000.0
2007-08-22 06:50:00	SPY	ETF	146.01	146.09	146.01	146.09	6100.0
2007-08-22 06:55:00	SPY	ETF	146.1	146.1	146.05	146.05	10300.0
2007-08-22 07:00:00	SPY	ETF	146.0	146.05	145.98	146.0	76700.0
2007-08-22 07:05:00	SPY	ETF	146.0	146.06	145.96	146.0	30300.0
2007-08-22 07:10:00	SPY	ETF	146.0	146.01	145.92	145.95	43800.0
2007-08-22 07:15:00	SPY	ETF	145.95	145.97	145.9	145.9	46900.0
2007-08-22 07:20:00	SPY	ETF	145.9	145.93	145.85	145.93	44500.0
2007-08-22 07:25:00	SPY	ETF	145.9	145.9	145.88	145.88	19600.0
2007-08-22 07:30:00	SPY	ETF	145.92	145.93	145.88	145.93	72600.0
2007-08-22 07:35:00	SPY	ETF	145.9	145.95	145.78	145.81	195200.0
2007-08-22 07:40:00	SPY	ETF	145.81	145.83	145.75	145.78	70200.0
2007-08-22 07:45:00	SPY	ETF	145.78	145.82	145.76	145.8	47200.0
2007-08-22 07:50:00	SPY	ETF	145.8	145.95	145.79	145.95	74000.0
2007-08-22 07:55:00	SPY	ETF	145.95	145.95	145.79	145.83	47200.0
2007-08-22 08:00:00	SPY	ETF	145.83	146.0	145.79	145.8	327100.0
2007-08-22 08:05:00	SPY	ETF	145.81	145.89	145.79	145.89	179800.0
2007-08-22 08:10:00	SPY	ETF	145.84	145.86	145.79	145.81	151100.0
2007-08-22 08:15:00	SPY	ETF	145.82	146.0	145.82	145.97	122200.0
2007-08-22 08:20:00	SPY	ETF	145.99	146.0	145.85	145.9	276200.0
2007-08-22 08:25:00	SPY	ETF	145.9	146.125	145.8	145.9	102100.0
2007-08-22 08:30:00	SPY	ETF	145.88	145.88	145.78	145.83	94300.0
2007-08-22 08:35:00	SPY	ETF	145.83	145.92	145.81	145.92	93900.0
2007-08-22 08:40:00	SPY	ETF	145.94	145.96	145.9	145.95	37400.0
2007-08-22 08:45:00	SPY	ETF	145.95	145.98	145.95	145.97	55000.0
2007-08-22 08:50:00	SPY	ETF	145.98	146.04	145.97	146.03	137900.0
2007-08-22 08:55:00	SPY	ETF	146.0	146.0	145.94	145.99	97300.0
2007-08-22 09:00:00	SPY	ETF	146.0	146.06	145.96	145.97	57300.0
2007-08-22 09:05:00	SPY	ETF	146.0	146.01	145.91	145.91	121700.0
2007-08-22 09:10:00	SPY	ETF	145.92	146.06	145.87	146.03	186200.0
2007-08-22 09:15:00	SPY	ETF	146.04	146.1	146.01	146.07	204000.0
2007-08-22 09:20:00	SPY	ETF	146.07	146.09	146.03	146.05	133500.0
2007-08-22 09:25:00	SPY	ETF	146.06	146.07	146.0	146.0	480400.0
2007-08-22 09:30:00	SPY	ETF	146.01	146.34	146.01	146.26	7294224.0
2007-08-22 09:35:00	SPY	ETF	146.26	146.57	146.23	146.4301	6179700.0
2007-08-22 09:40:00	SPY	ETF	146.44	146.6	146.3	146.43	4277000.0
2007-08-22 09:45:00	SPY	ETF	146.42	146.46	146.23	146.31	2889000.0
2007-08-22 09:50:00	SPY	ETF	146.3	146.4	146.22	146.37	1677700.0
2007-08-22 09:55:00	SPY	ETF	146.37	146.4	146.24	146.29	1653600.0
2007-08-22 10:00:00	SPY	ETF	146.29	146.36	146.18	146.24	2607900.0
2007-08-22 10:05:00	SPY	ETF	146.24	146.44	146.21	146.32	2744100.0
2007-08-22 10:10:00	SPY	ETF	146.33	146.45	146.31	146.34	2239300.0

> showing 50 of 18,335 rows — these rows as CSV

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