PREVIEW / etf_5min / 2007-06-21

all etf 5-min files

  file:    by_date/etf_5min/2007/2007-06-21.parquet
  size:    335 KB
  rows:    17,090

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-06-21 04:55:00	SPY	ETF	151.44	151.44	151.44	151.44	1000.0
2007-06-21 05:05:00	SPY	ETF	151.42	151.42	151.42	151.42	2000.0
2007-06-21 05:35:00	SPY	ETF	151.4	151.4	151.4	151.4	1000.0
2007-06-21 05:40:00	SPY	ETF	151.39	151.39	151.38	151.38	2000.0
2007-06-21 06:25:00	SPY	ETF	151.24	151.24	151.19	151.19	11500.0
2007-06-21 06:30:00	SPY	ETF	151.25	151.25	151.25	151.25	10000.0
2007-06-21 06:55:00	SPY	ETF	151.3	151.3	151.24	151.25	101400.0
2007-06-21 07:00:00	SPY	ETF	151.21	151.21	151.12	151.12	18200.0
2007-06-21 07:05:00	SPY	ETF	151.12	151.2	151.12	151.2	57400.0
2007-06-21 07:10:00	SPY	ETF	151.22	151.25	151.21	151.25	14900.0
2007-06-21 07:15:00	SPY	ETF	151.14	151.19	151.1	151.1	48400.0
2007-06-21 07:20:00	SPY	ETF	151.1	151.11	151.01	151.01	83300.0
2007-06-21 07:25:00	SPY	ETF	151.06	151.09	150.89	150.91	163900.0
2007-06-21 07:30:00	SPY	ETF	150.92	151.02	150.91	150.99	111000.0
2007-06-21 07:35:00	SPY	ETF	150.95	150.95	150.84	150.95	488300.0
2007-06-21 07:40:00	SPY	ETF	150.95	150.95	150.82	150.87	193600.0
2007-06-21 07:45:00	SPY	ETF	150.82	150.83	150.6	150.68	844600.0
2007-06-21 07:50:00	SPY	ETF	150.7	150.85	150.7	150.78	232500.0
2007-06-21 07:55:00	SPY	ETF	150.85	150.93	150.82	150.83	118600.0
2007-06-21 08:00:00	SPY	ETF	150.88	151.17	150.7	150.81	615400.0
2007-06-21 08:05:00	SPY	ETF	150.77	150.83	150.71	150.79	560500.0
2007-06-21 08:10:00	SPY	ETF	150.81	151.03	150.8	151.03	215900.0
2007-06-21 08:15:00	SPY	ETF	151.04	151.05	150.93	150.97	134500.0
2007-06-21 08:20:00	SPY	ETF	150.99	150.99	150.85	150.85	363500.0
2007-06-21 08:25:00	SPY	ETF	150.89	150.94	150.84	150.86	262500.0
2007-06-21 08:30:00	SPY	ETF	150.84	151.07	150.83	151.02	796100.0
2007-06-21 08:35:00	SPY	ETF	151.03	151.15	151.0	151.05	356200.0
2007-06-21 08:40:00	SPY	ETF	151.04	151.08	150.95	150.95	492600.0
2007-06-21 08:45:00	SPY	ETF	150.96	150.99	150.92	150.96	89500.0
2007-06-21 08:50:00	SPY	ETF	150.97	151.1	150.96	151.1	153900.0
2007-06-21 08:55:00	SPY	ETF	151.1	151.23	151.03	151.22	452000.0
2007-06-21 09:00:00	SPY	ETF	151.22	151.22	151.11	151.11	450600.0
2007-06-21 09:05:00	SPY	ETF	151.11	151.22	151.09	151.16	483700.0
2007-06-21 09:10:00	SPY	ETF	151.15	151.17	151.05	151.07	86100.0
2007-06-21 09:15:00	SPY	ETF	151.07	151.08	150.94	150.94	410100.0
2007-06-21 09:20:00	SPY	ETF	150.95	151.05	150.95	151.01	822900.0
2007-06-21 09:25:00	SPY	ETF	151.0	151.12	150.99	151.06	312100.0
2007-06-21 09:30:00	SPY	ETF	151.08	151.2674	150.91	151.24	3018800.0
2007-06-21 09:35:00	SPY	ETF	151.23	151.27	150.86	150.93	3706506.0
2007-06-21 09:40:00	SPY	ETF	150.93	151.23	150.76	150.8	4572892.0
2007-06-21 09:45:00	SPY	ETF	150.79	150.86	150.7	150.78	2224801.0
2007-06-21 09:50:00	SPY	ETF	150.78	150.92	150.77	150.83	2356600.0
2007-06-21 09:55:00	SPY	ETF	150.83	150.84	150.36	150.38	4708073.0
2007-06-21 10:00:00	SPY	ETF	150.38	150.82	150.25	150.43	7323196.0
2007-06-21 10:05:00	SPY	ETF	150.43	150.6	150.38	150.6	5506177.0
2007-06-21 10:10:00	SPY	ETF	150.6	150.74	150.51	150.65	4446865.0
2007-06-21 10:15:00	SPY	ETF	150.65	151.23	150.65	151.23	9306514.0
2007-06-21 10:20:00	SPY	ETF	151.23	151.39	151.07	151.25	6531141.0
2007-06-21 10:25:00	SPY	ETF	151.24	151.47	151.22	151.24	5461937.0
2007-06-21 10:30:00	SPY	ETF	151.25	151.32	150.96	150.99	4719922.0

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

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