PREVIEW / etf_5min / 2007-07-19

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-07-19.parquet
  size:    303 KB
  rows:    17,201

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-07-19 04:20:00	SPY	ETF	154.89	154.89	154.89	154.89	4900.0
2007-07-19 04:30:00	SPY	ETF	154.86	154.86	154.86	154.86	3000.0
2007-07-19 05:30:00	SPY	ETF	154.82	154.82	154.82	154.82	6500.0
2007-07-19 05:35:00	SPY	ETF	154.81	154.82	154.81	154.82	7300.0
2007-07-19 05:55:00	SPY	ETF	154.87	154.87	154.87	154.87	22500.0
2007-07-19 06:25:00	SPY	ETF	154.77	154.77	154.77	154.77	100.0
2007-07-19 06:35:00	SPY	ETF	154.87	154.87	154.87	154.87	1500.0
2007-07-19 06:40:00	SPY	ETF	154.87	154.95	154.87	154.95	15000.0
2007-07-19 06:45:00	SPY	ETF	154.95	154.99	154.95	154.99	16500.0
2007-07-19 06:50:00	SPY	ETF	154.99	154.99	154.95	154.95	2400.0
2007-07-19 06:55:00	SPY	ETF	154.97	155.0	154.97	155.0	55800.0
2007-07-19 07:00:00	SPY	ETF	154.99	155.0	154.98	155.0	22500.0
2007-07-19 07:05:00	SPY	ETF	155.0	155.1	155.0	155.05	244700.0
2007-07-19 07:10:00	SPY	ETF	155.06	155.08	155.05	155.08	288700.0
2007-07-19 07:15:00	SPY	ETF	155.1	155.11	155.08	155.11	124300.0
2007-07-19 07:20:00	SPY	ETF	155.11	155.14	155.1	155.1	60500.0
2007-07-19 07:25:00	SPY	ETF	155.11	155.14	155.1	155.1	90300.0
2007-07-19 07:30:00	SPY	ETF	155.08	155.1	154.98	154.98	60700.0
2007-07-19 07:35:00	SPY	ETF	155.04	155.05	155.0	155.03	46100.0
2007-07-19 07:40:00	SPY	ETF	155.0	155.01	154.99	154.99	130100.0
2007-07-19 07:45:00	SPY	ETF	155.0	155.05	155.0	155.05	108500.0
2007-07-19 07:50:00	SPY	ETF	155.0	155.01	155.0	155.01	900.0
2007-07-19 07:55:00	SPY	ETF	155.03	155.06	155.03	155.03	39000.0
2007-07-19 08:00:00	SPY	ETF	154.61	155.05	154.3	155.02	351500.0
2007-07-19 08:05:00	SPY	ETF	155.03	155.04	154.99	155.0	33700.0
2007-07-19 08:10:00	SPY	ETF	155.01	155.05	155.0	155.04	14600.0
2007-07-19 08:15:00	SPY	ETF	155.04	155.09	155.04	155.07	246600.0
2007-07-19 08:20:00	SPY	ETF	155.07	155.11	155.05	155.1	371100.0
2007-07-19 08:25:00	SPY	ETF	155.11	155.12	155.04	155.05	219000.0
2007-07-19 08:30:00	SPY	ETF	155.09	155.23	155.07	155.18	787900.0
2007-07-19 08:35:00	SPY	ETF	155.17	155.26	155.17	155.24	832500.0
2007-07-19 08:40:00	SPY	ETF	155.24	155.27	155.21	155.23	430300.0
2007-07-19 08:45:00	SPY	ETF	155.23	155.26	155.2	155.21	249907.0
2007-07-19 08:50:00	SPY	ETF	155.21	155.25	155.21	155.24	175200.0
2007-07-19 08:55:00	SPY	ETF	155.24	155.28	155.23	155.27	108700.0
2007-07-19 09:00:00	SPY	ETF	155.27	155.31	155.27	155.29	161500.0
2007-07-19 09:05:00	SPY	ETF	155.28	155.32	155.28	155.3	243600.0
2007-07-19 09:10:00	SPY	ETF	155.29	155.29	155.22	155.25	740922.0
2007-07-19 09:15:00	SPY	ETF	155.25	155.3	155.24	155.29	261200.0
2007-07-19 09:20:00	SPY	ETF	155.28	155.28	155.23	155.25	154300.0
2007-07-19 09:25:00	SPY	ETF	155.25	155.25	155.19	155.19	298679.0
2007-07-19 09:30:00	SPY	ETF	155.2	155.38	155.14	155.34	3388800.0
2007-07-19 09:35:00	SPY	ETF	155.34	155.48	155.31	155.45	4461486.0
2007-07-19 09:40:00	SPY	ETF	155.44	155.53	155.37	155.41	4406680.0
2007-07-19 09:45:00	SPY	ETF	155.41	155.43	155.25	155.33	2211009.0
2007-07-19 09:50:00	SPY	ETF	155.33	155.45	155.3	155.35	2396378.0
2007-07-19 09:55:00	SPY	ETF	155.35	155.38	155.29	155.34	1595868.0
2007-07-19 10:00:00	SPY	ETF	155.33	155.35	155.2	155.29	2706600.0
2007-07-19 10:05:00	SPY	ETF	155.28	155.37	155.26	155.37	1239704.0
2007-07-19 10:10:00	SPY	ETF	155.37	155.38	155.19	155.2	1420908.0

> showing 50 of 17,201 rows — these rows as CSV

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