PREVIEW / etf_5min / 2009-07-07

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-07.parquet
  size:    669 KB
  rows:    28,432

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
2009-07-07 04:30:00	SPY	ETF	89.82	89.82	89.82	89.82	500.0
2009-07-07 04:35:00	SPY	ETF	89.85	89.85	89.85	89.85	500.0
2009-07-07 04:55:00	SPY	ETF	90.03	90.03	90.03	90.03	100.0
2009-07-07 06:00:00	SPY	ETF	90.15	90.15	90.15	90.15	15000.0
2009-07-07 06:05:00	SPY	ETF	90.18	90.18	90.18	90.18	1000.0
2009-07-07 06:15:00	SPY	ETF	90.24	90.24	90.24	90.24	200.0
2009-07-07 06:25:00	SPY	ETF	90.17	90.17	90.17	90.17	100.0
2009-07-07 06:35:00	SPY	ETF	90.12	90.12	90.12	90.12	100.0
2009-07-07 06:40:00	SPY	ETF	90.1	90.1	90.1	90.1	100.0
2009-07-07 06:45:00	SPY	ETF	90.1	90.1	90.07	90.07	1400.0
2009-07-07 06:50:00	SPY	ETF	90.11	90.16	90.11	90.16	2200.0
2009-07-07 06:55:00	SPY	ETF	90.15	90.17	90.15	90.15	10300.0
2009-07-07 07:00:00	SPY	ETF	90.17	90.17	90.15	90.15	800.0
2009-07-07 07:05:00	SPY	ETF	90.09	90.15	90.08	90.15	6300.0
2009-07-07 07:10:00	SPY	ETF	90.11	90.16	90.11	90.16	15600.0
2009-07-07 07:15:00	SPY	ETF	90.18	90.2	90.18	90.2	18300.0
2009-07-07 07:20:00	SPY	ETF	90.17	90.21	90.16	90.21	11000.0
2009-07-07 07:25:00	SPY	ETF	90.23	90.24	90.18	90.2	27900.0
2009-07-07 07:30:00	SPY	ETF	90.18	90.22	90.16	90.22	58100.0
2009-07-07 07:35:00	SPY	ETF	90.22	90.22	90.19	90.19	51400.0
2009-07-07 07:40:00	SPY	ETF	90.2	90.2	90.11	90.12	5300.0
2009-07-07 07:45:00	SPY	ETF	90.12	90.13	90.1	90.12	6300.0
2009-07-07 07:50:00	SPY	ETF	90.13	90.13	90.11	90.11	2700.0
2009-07-07 07:55:00	SPY	ETF	90.13	90.15	89.97	89.97	30189.0
2009-07-07 08:00:00	SPY	ETF	89.98	89.98	89.73	89.76	150850.0
2009-07-07 08:05:00	SPY	ETF	89.76	89.8	89.69	89.8	108510.0
2009-07-07 08:10:00	SPY	ETF	89.81	89.81	89.71	89.76	564550.0
2009-07-07 08:15:00	SPY	ETF	89.75	89.84	89.75	89.84	64710.0
2009-07-07 08:20:00	SPY	ETF	89.84	89.88	89.83	89.84	78876.0
2009-07-07 08:25:00	SPY	ETF	89.84	89.85	89.76	89.77	189634.0
2009-07-07 08:30:00	SPY	ETF	89.77	89.83	89.76	89.83	69210.0
2009-07-07 08:35:00	SPY	ETF	89.83	89.86	89.77	89.84	69290.0
2009-07-07 08:40:00	SPY	ETF	89.84	89.85	89.81	89.85	45789.0
2009-07-07 08:45:00	SPY	ETF	89.85	89.87	89.82	89.87	62567.0
2009-07-07 08:50:00	SPY	ETF	89.86	89.86	89.78	89.8	40869.0
2009-07-07 08:55:00	SPY	ETF	89.8	89.82	89.73	89.73	83821.0
2009-07-07 09:00:00	SPY	ETF	89.75	89.79	89.68	89.69	280468.0
2009-07-07 09:05:00	SPY	ETF	89.68	89.76	89.67	89.69	252472.0
2009-07-07 09:10:00	SPY	ETF	89.69	89.76	89.69	89.76	73380.0
2009-07-07 09:15:00	SPY	ETF	89.76	89.76	89.71	89.71	34990.0
2009-07-07 09:20:00	SPY	ETF	89.71	89.76	89.6	89.65	405244.0
2009-07-07 09:25:00	SPY	ETF	89.64	89.73	89.63	89.72	206925.0
2009-07-07 09:30:00	SPY	ETF	89.71	89.82	89.61	89.68	4387575.0
2009-07-07 09:35:00	SPY	ETF	89.67	89.74	89.51	89.55	5258955.0
2009-07-07 09:40:00	SPY	ETF	89.55	89.57	89.41	89.42	3445013.0
2009-07-07 09:45:00	SPY	ETF	89.43	89.73	89.39	89.46	2259103.0
2009-07-07 09:50:00	SPY	ETF	89.46	89.69	89.46	89.66	3144060.0
2009-07-07 09:55:00	SPY	ETF	89.66	89.66	89.48	89.5601	2247107.0
2009-07-07 10:00:00	SPY	ETF	89.56	89.58	89.27	89.33	4237659.0
2009-07-07 10:05:00	SPY	ETF	89.34	89.41	89.26	89.36	1544764.0

> showing 50 of 28,432 rows — these rows as CSV

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