PREVIEW / etf_5min / 2009-09-25

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-09-25.parquet
  size:    708 KB
  rows:    29,675

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-09-25 04:40:00	SPY	ETF	105.09	105.1	105.09	105.1	400.0
2009-09-25 04:50:00	SPY	ETF	105.1	105.1	105.1	105.1	190.0
2009-09-25 05:45:00	SPY	ETF	105.09	105.09	105.09	105.09	2000.0
2009-09-25 06:00:00	SPY	ETF	105.24	105.26	105.24	105.26	400.0
2009-09-25 06:05:00	SPY	ETF	105.31	105.34	105.31	105.34	5200.0
2009-09-25 06:10:00	SPY	ETF	105.27	105.27	105.27	105.27	100.0
2009-09-25 06:15:00	SPY	ETF	105.26	105.26	105.26	105.26	100.0
2009-09-25 06:25:00	SPY	ETF	105.27	105.27	105.27	105.27	700.0
2009-09-25 06:30:00	SPY	ETF	105.24	105.24	105.22	105.24	30000.0
2009-09-25 06:50:00	SPY	ETF	105.16	105.16	105.16	105.16	100.0
2009-09-25 07:00:00	SPY	ETF	105.13	105.16	105.13	105.16	6100.0
2009-09-25 07:05:00	SPY	ETF	105.12	105.18	105.1	105.17	16674.0
2009-09-25 07:10:00	SPY	ETF	105.18	105.22	105.18	105.22	12003.0
2009-09-25 07:15:00	SPY	ETF	105.18	105.27	105.18	105.19	69200.0
2009-09-25 07:20:00	SPY	ETF	105.21	105.24	105.19	105.19	40400.0
2009-09-25 07:25:00	SPY	ETF	105.16	105.16	105.13	105.15	5200.0
2009-09-25 07:30:00	SPY	ETF	105.13	105.16	105.1	105.16	12794.0
2009-09-25 07:35:00	SPY	ETF	105.16	105.16	105.14	105.16	4550.0
2009-09-25 07:40:00	SPY	ETF	105.15	105.21	105.15	105.2	19963.0
2009-09-25 07:45:00	SPY	ETF	105.22	105.3	105.21	105.3	35998.0
2009-09-25 07:50:00	SPY	ETF	105.27	105.31	105.22	105.22	50657.0
2009-09-25 07:55:00	SPY	ETF	105.23	105.26	105.23	105.24	15500.0
2009-09-25 08:00:00	SPY	ETF	105.23	105.25	105.13	105.14	105808.0
2009-09-25 08:05:00	SPY	ETF	105.12	105.17	105.09	105.15	117500.0
2009-09-25 08:10:00	SPY	ETF	105.16	105.2	105.14	105.19	65451.0
2009-09-25 08:15:00	SPY	ETF	105.2	105.23	105.05	105.07	168395.0
2009-09-25 08:20:00	SPY	ETF	105.06	105.13	105.03	105.07	144793.0
2009-09-25 08:25:00	SPY	ETF	105.08	105.17	105.06	105.17	179856.0
2009-09-25 08:30:00	SPY	ETF	105.08	105.16	104.56	104.62	1573987.0
2009-09-25 08:35:00	SPY	ETF	104.63	104.64	104.43	104.53	763253.0
2009-09-25 08:40:00	SPY	ETF	104.54	104.61	104.5	104.55	746515.0
2009-09-25 08:45:00	SPY	ETF	104.55	104.72	104.54	104.7	303430.0
2009-09-25 08:50:00	SPY	ETF	104.7	104.71	104.62	104.64	79299.0
2009-09-25 08:55:00	SPY	ETF	104.64	104.66	104.62	104.65	99008.0
2009-09-25 09:00:00	SPY	ETF	104.65	104.65	104.6	104.64	87866.0
2009-09-25 09:05:00	SPY	ETF	104.64	104.73	104.63	104.66	116161.0
2009-09-25 09:10:00	SPY	ETF	104.66	104.67	104.63	104.65	89295.0
2009-09-25 09:15:00	SPY	ETF	104.65	104.69	104.62	104.67	145283.0
2009-09-25 09:20:00	SPY	ETF	104.66	104.82	104.65	104.79	259003.0
2009-09-25 09:25:00	SPY	ETF	104.79	104.84	104.73	104.78	649194.0
2009-09-25 09:30:00	SPY	ETF	104.78	104.84	104.61	104.71	4851122.0
2009-09-25 09:35:00	SPY	ETF	104.72	104.75	104.55	104.63	2424108.0
2009-09-25 09:40:00	SPY	ETF	104.64	105.07	104.55	105.06	3540645.0
2009-09-25 09:45:00	SPY	ETF	105.06	105.21	104.99	105.06	3651907.0
2009-09-25 09:50:00	SPY	ETF	105.06	105.16	104.83	104.9	4067881.0
2009-09-25 09:55:00	SPY	ETF	104.92	105.28	104.89	105.01	5714222.0
2009-09-25 10:00:00	SPY	ETF	105.01	105.13	104.69	105.02	5404565.0
2009-09-25 10:05:00	SPY	ETF	105.01	105.32	104.96	105.31	3391355.0
2009-09-25 10:10:00	SPY	ETF	105.32	105.36	105.11	105.16	3285377.0
2009-09-25 10:15:00	SPY	ETF	105.16	105.3	105.13	105.2	1517369.0

> showing 50 of 29,675 rows — these rows as CSV

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