PREVIEW / etf_5min / 2010-10-27

all etf 5-min files

  file:    by_date/etf_5min/2010/2010-10-27.parquet
  size:    819 KB
  rows:    34,265

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
2010-10-27 04:00:00	SPY	ETF	118.67	118.67	118.09	118.14	2825.0
2010-10-27 04:05:00	SPY	ETF	118.06	118.06	118.06	118.06	100.0
2010-10-27 04:20:00	SPY	ETF	118.05	118.05	118.05	118.05	250.0
2010-10-27 04:30:00	SPY	ETF	118.11	118.11	118.11	118.11	1000.0
2010-10-27 04:40:00	SPY	ETF	118.1	118.14	118.08	118.08	16200.0
2010-10-27 04:50:00	SPY	ETF	118.0	118.0	117.99	117.99	1300.0
2010-10-27 04:55:00	SPY	ETF	117.99	118.01	117.99	118.01	250.0
2010-10-27 05:00:00	SPY	ETF	118.03	118.03	118.03	118.03	100.0
2010-10-27 05:10:00	SPY	ETF	118.03	118.03	118.03	118.03	100.0
2010-10-27 05:15:00	SPY	ETF	118.0	118.0	117.96	117.96	3701.0
2010-10-27 05:20:00	SPY	ETF	117.9	117.93	117.9	117.93	3600.0
2010-10-27 05:25:00	SPY	ETF	118.0	118.0	118.0	118.0	200.0
2010-10-27 05:35:00	SPY	ETF	118.25	118.38	118.25	118.38	2300.0
2010-10-27 05:40:00	SPY	ETF	118.33	118.38	118.33	118.38	1800.0
2010-10-27 05:45:00	SPY	ETF	118.3	118.3	118.3	118.3	100.0
2010-10-27 05:50:00	SPY	ETF	118.38	118.38	118.38	118.38	500.0
2010-10-27 06:00:00	SPY	ETF	118.24	118.32	118.2	118.25	54600.0
2010-10-27 06:05:00	SPY	ETF	118.23	118.25	118.23	118.25	7000.0
2010-10-27 06:15:00	SPY	ETF	118.28	118.28	118.26	118.26	600.0
2010-10-27 06:25:00	SPY	ETF	118.27	118.27	118.25	118.25	2000.0
2010-10-27 06:30:00	SPY	ETF	118.24	118.24	118.24	118.24	900.0
2010-10-27 06:35:00	SPY	ETF	118.23	118.27	118.23	118.27	6500.0
2010-10-27 06:40:00	SPY	ETF	118.24	118.31	118.24	118.31	800.0
2010-10-27 06:45:00	SPY	ETF	118.35	118.39	118.35	118.35	14500.0
2010-10-27 06:50:00	SPY	ETF	118.36	118.37	118.34	118.37	2550.0
2010-10-27 07:00:00	SPY	ETF	118.3	118.32	118.25	118.28	25300.0
2010-10-27 07:05:00	SPY	ETF	118.28	118.33	118.28	118.32	8300.0
2010-10-27 07:10:00	SPY	ETF	118.32	118.34	118.3	118.3	3400.0
2010-10-27 07:15:00	SPY	ETF	118.25	118.26	118.2	118.26	27745.0
2010-10-27 07:20:00	SPY	ETF	118.21	118.21	118.14	118.2	10100.0
2010-10-27 07:25:00	SPY	ETF	118.21	118.21	118.18	118.21	96700.0
2010-10-27 07:30:00	SPY	ETF	118.22	118.24	118.1	118.1	25100.0
2010-10-27 07:35:00	SPY	ETF	118.14	118.16	118.1	118.16	130225.0
2010-10-27 07:40:00	SPY	ETF	118.15	118.2	118.13	118.15	30000.0
2010-10-27 07:45:00	SPY	ETF	118.14	118.16	118.08	118.08	13300.0
2010-10-27 07:50:00	SPY	ETF	118.11	118.11	118.05	118.11	49580.0
2010-10-27 07:55:00	SPY	ETF	118.14	118.16	118.12	118.12	8900.0
2010-10-27 08:00:00	SPY	ETF	118.13	118.31	117.83	118.14	570282.0
2010-10-27 08:05:00	SPY	ETF	118.15	118.19	118.15	118.19	27344.0
2010-10-27 08:10:00	SPY	ETF	118.2	118.24	118.18	118.18	41716.0
2010-10-27 08:15:00	SPY	ETF	118.18	118.25	118.16	118.24	34600.0
2010-10-27 08:20:00	SPY	ETF	118.24	118.25	118.17	118.19	74131.0
2010-10-27 08:25:00	SPY	ETF	118.19	118.22	118.16	118.2	51931.0
2010-10-27 08:30:00	SPY	ETF	118.18	118.21	118.01	118.17	622722.0
2010-10-27 08:35:00	SPY	ETF	118.18	118.19	118.11	118.14	161790.0
2010-10-27 08:40:00	SPY	ETF	118.14	118.17	118.1	118.13	83991.0
2010-10-27 08:45:00	SPY	ETF	118.12	118.13	117.98	118.03	633662.0
2010-10-27 08:50:00	SPY	ETF	118.01	118.01	117.85	117.9	489894.0
2010-10-27 08:55:00	SPY	ETF	117.9	117.98	117.89	117.97	257475.0
2010-10-27 09:00:00	SPY	ETF	117.96	118.11	117.93	118.08	159680.0

> showing 50 of 34,265 rows — these rows as CSV

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