PREVIEW / etf_5min / 2009-10-19

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-10-19.parquet
  size:    743 KB
  rows:    30,961

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-10-19 04:15:00	SPY	ETF	109.28	109.28	109.23	109.27	2600.0
2009-10-19 04:50:00	SPY	ETF	109.23	109.23	109.23	109.23	100.0
2009-10-19 05:15:00	SPY	ETF	109.25	109.26	109.25	109.26	253.0
2009-10-19 05:35:00	SPY	ETF	109.25	109.27	109.25	109.27	5100.0
2009-10-19 05:50:00	SPY	ETF	109.3	109.3	109.3	109.3	25000.0
2009-10-19 05:55:00	SPY	ETF	109.25	109.25	109.25	109.25	100.0
2009-10-19 06:10:00	SPY	ETF	109.25	109.25	109.25	109.25	400.0
2009-10-19 06:25:00	SPY	ETF	109.25	109.25	109.25	109.25	1100.0
2009-10-19 06:40:00	SPY	ETF	109.2	109.23	109.2	109.22	7700.0
2009-10-19 06:45:00	SPY	ETF	109.27	109.27	109.27	109.27	2499.0
2009-10-19 06:50:00	SPY	ETF	109.24	109.24	109.24	109.24	2500.0
2009-10-19 06:55:00	SPY	ETF	109.24	109.27	109.24	109.27	18100.0
2009-10-19 07:00:00	SPY	ETF	109.27	109.31	109.25	109.3	40186.0
2009-10-19 07:05:00	SPY	ETF	109.31	109.37	109.3	109.34	58539.0
2009-10-19 07:10:00	SPY	ETF	109.34	109.36	109.32	109.32	42500.0
2009-10-19 07:15:00	SPY	ETF	109.32	109.35	109.28	109.3	76900.0
2009-10-19 07:20:00	SPY	ETF	109.3	109.32	109.3	109.31	30000.0
2009-10-19 07:25:00	SPY	ETF	109.32	109.33	109.3	109.32	28700.0
2009-10-19 07:30:00	SPY	ETF	109.31	109.31	109.25	109.25	68900.0
2009-10-19 07:35:00	SPY	ETF	109.24	109.26	109.22	109.25	10650.0
2009-10-19 07:40:00	SPY	ETF	109.25	109.28	109.22	109.27	33507.0
2009-10-19 07:45:00	SPY	ETF	109.25	109.25	109.23	109.25	4900.0
2009-10-19 07:50:00	SPY	ETF	109.26	109.33	109.26	109.33	45002.0
2009-10-19 07:55:00	SPY	ETF	109.3	109.32	109.28	109.28	28999.0
2009-10-19 08:00:00	SPY	ETF	109.28	109.43	108.0	109.22	109283.0
2009-10-19 08:05:00	SPY	ETF	109.22	109.23	109.2	109.2	51984.0
2009-10-19 08:10:00	SPY	ETF	109.2	109.2	109.14	109.15	116796.0
2009-10-19 08:15:00	SPY	ETF	109.15	109.15	109.11	109.12	118656.0
2009-10-19 08:20:00	SPY	ETF	109.12	109.19	109.12	109.19	85502.0
2009-10-19 08:25:00	SPY	ETF	109.19	109.24	109.18	109.2	105120.0
2009-10-19 08:30:00	SPY	ETF	109.2	109.24	109.17	109.23	115986.0
2009-10-19 08:35:00	SPY	ETF	109.22	109.27	109.2	109.27	247585.0
2009-10-19 08:40:00	SPY	ETF	109.26	109.27	109.21	109.22	198198.0
2009-10-19 08:45:00	SPY	ETF	109.22	109.22	108.52	109.19	138173.0
2009-10-19 08:50:00	SPY	ETF	109.18	109.2	109.13	109.18	179116.0
2009-10-19 08:55:00	SPY	ETF	109.18	109.22	109.18	109.2	136655.0
2009-10-19 09:00:00	SPY	ETF	109.2	109.22	109.14	109.16	193314.0
2009-10-19 09:05:00	SPY	ETF	109.16	109.17	109.11	109.14	148711.0
2009-10-19 09:10:00	SPY	ETF	109.13	109.14	109.13	109.13	32221.0
2009-10-19 09:15:00	SPY	ETF	109.13	109.18	109.11	109.18	157887.0
2009-10-19 09:20:00	SPY	ETF	109.18	109.18	109.1	109.11	114088.0
2009-10-19 09:25:00	SPY	ETF	109.1	109.1	109.02	109.05	153927.0
2009-10-19 09:30:00	SPY	ETF	109.07	109.11	108.94	108.96	2848996.0
2009-10-19 09:35:00	SPY	ETF	108.96	109.2	108.95	109.11	3229782.0
2009-10-19 09:40:00	SPY	ETF	109.109	109.24	109.02	109.04	2953902.0
2009-10-19 09:45:00	SPY	ETF	109.05	109.06	108.9	109.06	2641462.0
2009-10-19 09:50:00	SPY	ETF	109.06	109.06	108.81	108.82	1728553.0
2009-10-19 09:55:00	SPY	ETF	108.81	108.85	108.73	108.8284	2521683.0
2009-10-19 10:00:00	SPY	ETF	108.8299	109.22	108.78	108.99	2708133.0
2009-10-19 10:05:00	SPY	ETF	108.99	109.08	108.83	109.02	2848223.0

> showing 50 of 30,961 rows — these rows as CSV

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