PREVIEW / etf_5min / 2007-07-30

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-07-30.parquet
  size:    403 KB
  rows:    19,114

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-30 04:15:00	SPY	ETF	146.04	146.09	146.04	146.09	4700.0
2007-07-30 05:00:00	SPY	ETF	145.67	145.7	145.65	145.7	5700.0
2007-07-30 05:05:00	SPY	ETF	145.72	145.72	145.71	145.71	5000.0
2007-07-30 05:10:00	SPY	ETF	145.65	145.65	145.65	145.65	1000.0
2007-07-30 05:20:00	SPY	ETF	145.68	145.69	145.68	145.69	200.0
2007-07-30 05:25:00	SPY	ETF	145.77	145.83	145.77	145.83	5200.0
2007-07-30 06:10:00	SPY	ETF	145.64	145.69	145.64	145.69	50400.0
2007-07-30 06:15:00	SPY	ETF	145.69	145.69	145.66	145.67	52700.0
2007-07-30 06:20:00	SPY	ETF	145.72	145.72	145.51	145.51	1800.0
2007-07-30 06:25:00	SPY	ETF	145.45	145.54	145.45	145.46	267000.0
2007-07-30 06:30:00	SPY	ETF	145.46	145.46	145.32	145.32	34700.0
2007-07-30 06:35:00	SPY	ETF	145.21	145.21	145.08	145.15	106200.0
2007-07-30 06:40:00	SPY	ETF	145.08	145.16	144.9	145.05	152800.0
2007-07-30 06:45:00	SPY	ETF	145.11	145.11	145.0	145.0	38200.0
2007-07-30 06:50:00	SPY	ETF	145.0	145.11	144.96	145.11	182900.0
2007-07-30 06:55:00	SPY	ETF	145.05	145.2	145.05	145.2	105000.0
2007-07-30 07:00:00	SPY	ETF	145.36	145.6	145.34	145.49	155300.0
2007-07-30 07:05:00	SPY	ETF	145.58	145.6	145.45	145.46	235400.0
2007-07-30 07:10:00	SPY	ETF	145.47	145.47	145.3	145.31	305000.0
2007-07-30 07:15:00	SPY	ETF	145.34	145.41	145.3	145.37	47400.0
2007-07-30 07:20:00	SPY	ETF	145.41	145.41	145.1	145.1	354400.0
2007-07-30 07:25:00	SPY	ETF	145.12	145.16	145.1	145.15	386100.0
2007-07-30 07:30:00	SPY	ETF	145.14	145.27	145.13	145.25	152500.0
2007-07-30 07:35:00	SPY	ETF	145.22	145.48	145.21	145.32	282100.0
2007-07-30 07:40:00	SPY	ETF	145.35	145.45	145.29	145.4	144600.0
2007-07-30 07:45:00	SPY	ETF	145.4	145.4	145.31	145.35	77200.0
2007-07-30 07:50:00	SPY	ETF	145.35	145.4	145.21	145.33	292200.0
2007-07-30 07:55:00	SPY	ETF	145.34	145.4	145.24	145.27	221600.0
2007-07-30 08:00:00	SPY	ETF	145.3	145.82	144.98	145.03	1673500.0
2007-07-30 08:05:00	SPY	ETF	145.03	145.3	145.0	145.29	530800.0
2007-07-30 08:10:00	SPY	ETF	145.3	145.4	145.1	145.36	411900.0
2007-07-30 08:15:00	SPY	ETF	145.36	145.53	145.26	145.49	1103600.0
2007-07-30 08:20:00	SPY	ETF	145.5	145.77	145.08	145.72	555300.0
2007-07-30 08:25:00	SPY	ETF	145.72	146.0	145.25	145.64	703400.0
2007-07-30 08:30:00	SPY	ETF	145.64	145.88	145.64	145.85	706100.0
2007-07-30 08:35:00	SPY	ETF	145.85	146.0	145.77	145.99	1248900.0
2007-07-30 08:40:00	SPY	ETF	145.98	146.0	145.79	145.84	1488000.0
2007-07-30 08:45:00	SPY	ETF	145.85	145.93	145.81	145.84	471900.0
2007-07-30 08:50:00	SPY	ETF	145.83	145.88	145.76	145.87	678900.0
2007-07-30 08:55:00	SPY	ETF	145.89	145.93	145.84	145.9	369600.0
2007-07-30 09:00:00	SPY	ETF	145.89	146.12	145.89	146.03	861400.0
2007-07-30 09:05:00	SPY	ETF	146.02	146.06	145.98	146.01	834000.0
2007-07-30 09:10:00	SPY	ETF	146.01	146.06	145.53	145.96	1126600.0
2007-07-30 09:15:00	SPY	ETF	145.98	145.99	145.89	145.94	223700.0
2007-07-30 09:20:00	SPY	ETF	145.94	146.0	145.91	145.98	265062.0
2007-07-30 09:25:00	SPY	ETF	145.97	145.97	145.84	145.9	187600.0
2007-07-30 09:30:00	SPY	ETF	145.93	146.33	145.91	146.27	10829037.0
2007-07-30 09:35:00	SPY	ETF	146.27	146.28	145.64	145.69	6317828.0
2007-07-30 09:40:00	SPY	ETF	145.68	145.82	145.33	145.62	5988624.0
2007-07-30 09:45:00	SPY	ETF	145.62	146.07	145.48	145.96	5107244.0

> showing 50 of 19,114 rows — these rows as CSV

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