PREVIEW / etf_5min / 2007-10-25

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-10-25.parquet
  size:    414 KB
  rows:    19,849

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-10-25 04:40:00	SPY	ETF	151.39	151.39	151.39	151.39	2000.0
2007-10-25 05:30:00	SPY	ETF	151.43	151.44	151.43	151.43	18500.0
2007-10-25 05:35:00	SPY	ETF	151.44	151.44	151.44	151.44	100.0
2007-10-25 05:40:00	SPY	ETF	151.5	151.5	151.5	151.5	2000.0
2007-10-25 05:45:00	SPY	ETF	151.5	151.5	151.5	151.5	28000.0
2007-10-25 05:55:00	SPY	ETF	151.53	151.53	151.53	151.53	12500.0
2007-10-25 06:00:00	SPY	ETF	151.51	151.51	151.51	151.51	2000.0
2007-10-25 06:30:00	SPY	ETF	151.48	151.54	151.48	151.54	60000.0
2007-10-25 06:40:00	SPY	ETF	151.53	151.57	151.53	151.57	1600.0
2007-10-25 06:45:00	SPY	ETF	151.67	151.67	151.67	151.67	200.0
2007-10-25 06:50:00	SPY	ETF	151.73	151.75	151.73	151.75	1100.0
2007-10-25 07:00:00	SPY	ETF	151.79	151.94	151.79	151.92	325300.0
2007-10-25 07:05:00	SPY	ETF	151.94	152.17	151.94	152.14	346400.0
2007-10-25 07:10:00	SPY	ETF	152.15	152.17	152.1	152.17	13500.0
2007-10-25 07:15:00	SPY	ETF	152.17	152.22	152.17	152.18	164900.0
2007-10-25 07:20:00	SPY	ETF	152.16	152.17	152.12	152.12	376000.0
2007-10-25 07:25:00	SPY	ETF	152.15	152.2	152.12	152.2	67900.0
2007-10-25 07:30:00	SPY	ETF	152.2	152.2	152.16	152.19	36100.0
2007-10-25 07:35:00	SPY	ETF	152.18	152.19	152.06	152.06	12500.0
2007-10-25 07:40:00	SPY	ETF	152.1	152.1	152.06	152.1	15000.0
2007-10-25 07:45:00	SPY	ETF	152.1	152.1	152.02	152.07	17100.0
2007-10-25 07:50:00	SPY	ETF	152.08	152.1	152.04	152.04	26300.0
2007-10-25 07:55:00	SPY	ETF	152.05	152.05	152.0	152.0	57400.0
2007-10-25 08:00:00	SPY	ETF	152.0	152.05	151.48	152.0	170400.0
2007-10-25 08:05:00	SPY	ETF	152.0	152.01	151.92	151.92	45900.0
2007-10-25 08:10:00	SPY	ETF	151.95	152.04	151.86	151.87	443400.0
2007-10-25 08:15:00	SPY	ETF	151.88	151.91	151.8	151.84	603600.0
2007-10-25 08:20:00	SPY	ETF	151.84	151.92	151.83	151.87	145300.0
2007-10-25 08:25:00	SPY	ETF	151.87	151.92	151.84	151.84	71600.0
2007-10-25 08:30:00	SPY	ETF	151.83	151.86	151.57	151.82	2010200.0
2007-10-25 08:35:00	SPY	ETF	151.8	151.96	151.79	151.94	339000.0
2007-10-25 08:40:00	SPY	ETF	151.95	152.14	151.95	151.99	635400.0
2007-10-25 08:45:00	SPY	ETF	152.01	152.17	151.91	151.94	807400.0
2007-10-25 08:50:00	SPY	ETF	151.93	152.01	151.93	151.98	197400.0
2007-10-25 08:55:00	SPY	ETF	151.98	151.99	151.87	151.87	221600.0
2007-10-25 09:00:00	SPY	ETF	151.88	151.91	151.72	151.77	404400.0
2007-10-25 09:05:00	SPY	ETF	151.79	151.82	151.72	151.81	111900.0
2007-10-25 09:10:00	SPY	ETF	151.78	151.86	151.73	151.83	169600.0
2007-10-25 09:15:00	SPY	ETF	151.8	151.83	151.71	151.75	74905.0
2007-10-25 09:20:00	SPY	ETF	151.73	151.73	151.64	151.68	192300.0
2007-10-25 09:25:00	SPY	ETF	151.68	151.76	151.67	151.69	87800.0
2007-10-25 09:30:00	SPY	ETF	151.68	151.73	151.5	151.56	2830236.0
2007-10-25 09:35:00	SPY	ETF	151.56	151.65	151.06	151.1	4087688.0
2007-10-25 09:40:00	SPY	ETF	151.1	151.4	151.03	151.32	6814900.0
2007-10-25 09:45:00	SPY	ETF	151.32	151.36	151.2	151.32	1464700.0
2007-10-25 09:50:00	SPY	ETF	151.31	151.39	151.16	151.21	2343300.0
2007-10-25 09:55:00	SPY	ETF	151.2	151.2	150.83	150.9	2856600.0
2007-10-25 10:00:00	SPY	ETF	150.91	151.41	150.9	151.41	4972200.0
2007-10-25 10:05:00	SPY	ETF	151.41	151.55	151.32	151.44	2914900.0
2007-10-25 10:10:00	SPY	ETF	151.45	152.0	151.44	151.99	6238800.0

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

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