PREVIEW / etf_5min / 2009-10-27

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-10-27.parquet
  size:    757 KB
  rows:    31,156

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-27 04:15:00	SPY	ETF	107.21	107.21	107.21	107.21	260.0
2009-10-27 05:20:00	SPY	ETF	106.96	106.96	106.96	106.96	2000.0
2009-10-27 05:35:00	SPY	ETF	107.02	107.02	107.02	107.02	700.0
2009-10-27 05:55:00	SPY	ETF	107.06	107.06	107.06	107.06	1000.0
2009-10-27 06:00:00	SPY	ETF	107.14	107.14	107.14	107.14	1000.0
2009-10-27 06:10:00	SPY	ETF	107.14	107.14	107.06	107.06	450.0
2009-10-27 06:25:00	SPY	ETF	107.2	107.2	107.19	107.19	2600.0
2009-10-27 06:30:00	SPY	ETF	107.19	107.21	107.19	107.21	3233.0
2009-10-27 06:45:00	SPY	ETF	107.19	107.21	107.19	107.21	6733.0
2009-10-27 06:55:00	SPY	ETF	107.22	107.27	107.22	107.27	2000.0
2009-10-27 07:00:00	SPY	ETF	107.24	107.35	107.24	107.31	35713.0
2009-10-27 07:05:00	SPY	ETF	107.35	107.37	107.35	107.37	2650.0
2009-10-27 07:10:00	SPY	ETF	107.31	107.34	107.31	107.31	9000.0
2009-10-27 07:15:00	SPY	ETF	107.33	107.4	107.33	107.36	20800.0
2009-10-27 07:20:00	SPY	ETF	107.36	107.43	107.36	107.43	5230.0
2009-10-27 07:25:00	SPY	ETF	107.41	107.41	107.36	107.4	6800.0
2009-10-27 07:30:00	SPY	ETF	107.36	107.38	107.3	107.32	13018.0
2009-10-27 07:35:00	SPY	ETF	107.32	107.32	107.21	107.21	56400.0
2009-10-27 07:40:00	SPY	ETF	107.21	107.23	107.1	107.16	45216.0
2009-10-27 07:45:00	SPY	ETF	107.18	107.2	107.17	107.19	12104.0
2009-10-27 07:50:00	SPY	ETF	107.18	107.25	107.18	107.25	5400.0
2009-10-27 07:55:00	SPY	ETF	107.27	107.27	107.23	107.25	4299.0
2009-10-27 08:00:00	SPY	ETF	107.25	107.32	107.15	107.16	193847.0
2009-10-27 08:05:00	SPY	ETF	107.2	107.2	107.12	107.12	28351.0
2009-10-27 08:10:00	SPY	ETF	107.12	107.28	106.99	107.08	119464.0
2009-10-27 08:15:00	SPY	ETF	107.1	107.17	107.08	107.14	33128.0
2009-10-27 08:20:00	SPY	ETF	107.14	107.14	106.98	107.02	127253.0
2009-10-27 08:25:00	SPY	ETF	107.03	107.05	106.97	106.98	380922.0
2009-10-27 08:30:00	SPY	ETF	106.99	107.06	106.95	107.02	112895.0
2009-10-27 08:35:00	SPY	ETF	107.03	107.12	107.03	107.12	32509.0
2009-10-27 08:40:00	SPY	ETF	107.12	107.18	107.12	107.14	265964.0
2009-10-27 08:45:00	SPY	ETF	107.13	107.14	107.04	107.13	162276.0
2009-10-27 08:50:00	SPY	ETF	107.13	107.14	107.08	107.12	65742.0
2009-10-27 08:55:00	SPY	ETF	107.13	107.17	107.13	107.16	54431.0
2009-10-27 09:00:00	SPY	ETF	107.17	107.32	107.14	107.15	579825.0
2009-10-27 09:05:00	SPY	ETF	107.15	107.26	107.09	107.11	186495.0
2009-10-27 09:10:00	SPY	ETF	107.11	107.13	107.03	107.07	178333.0
2009-10-27 09:15:00	SPY	ETF	107.08	107.1	107.06	107.09	69262.0
2009-10-27 09:20:00	SPY	ETF	107.08	107.08	106.97	106.99	128986.0
2009-10-27 09:25:00	SPY	ETF	106.99	107.04	106.94	107.03	339018.0
2009-10-27 09:30:00	SPY	ETF	107.03	107.31	107.01	107.12	5471013.0
2009-10-27 09:35:00	SPY	ETF	107.13	107.28	107.06	107.07	5623308.0
2009-10-27 09:40:00	SPY	ETF	107.09	107.2	106.77	106.86	5928852.0
2009-10-27 09:45:00	SPY	ETF	106.87	107.11	106.76	107.0799	4214523.0
2009-10-27 09:50:00	SPY	ETF	107.07	107.34	106.8	107.27	5520862.0
2009-10-27 09:55:00	SPY	ETF	107.27	107.3	106.65	106.93	3393964.0
2009-10-27 10:00:00	SPY	ETF	106.93	106.98	106.16	106.48	18404151.0
2009-10-27 10:05:00	SPY	ETF	106.48	106.51	106.17	106.4283	5628283.0
2009-10-27 10:10:00	SPY	ETF	106.43	106.74	106.41	106.73	6918358.0
2009-10-27 10:15:00	SPY	ETF	106.73	106.78	106.54	106.611	3794542.0

> showing 50 of 31,156 rows — these rows as CSV

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