PREVIEW / etf_5min / 2009-05-18

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-05-18.parquet
  size:    686 KB
  rows:    29,766

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-05-18 04:15:00	SPY	ETF	88.65	88.7	88.65	88.68	800.0
2009-05-18 04:20:00	SPY	ETF	88.7	88.7	88.62	88.62	700.0
2009-05-18 04:25:00	SPY	ETF	88.63	88.63	88.6	88.6	700.0
2009-05-18 04:30:00	SPY	ETF	88.55	88.55	88.55	88.55	700.0
2009-05-18 04:40:00	SPY	ETF	88.68	88.68	88.68	88.68	300.0
2009-05-18 04:55:00	SPY	ETF	88.76	88.76	88.76	88.76	100.0
2009-05-18 05:00:00	SPY	ETF	88.93	89.06	88.93	89.06	900.0
2009-05-18 05:20:00	SPY	ETF	88.91	88.91	88.9	88.9	7500.0
2009-05-18 05:25:00	SPY	ETF	89.09	89.1	89.09	89.1	7700.0
2009-05-18 05:35:00	SPY	ETF	89.25	89.26	89.25	89.26	400.0
2009-05-18 05:40:00	SPY	ETF	89.33	89.35	89.32	89.35	500.0
2009-05-18 05:45:00	SPY	ETF	89.25	89.25	89.25	89.25	100.0
2009-05-18 05:50:00	SPY	ETF	89.29	89.29	89.29	89.29	5000.0
2009-05-18 05:55:00	SPY	ETF	89.19	89.19	89.19	89.19	5000.0
2009-05-18 06:05:00	SPY	ETF	89.19	89.25	89.19	89.23	925.0
2009-05-18 06:10:00	SPY	ETF	89.18	89.18	89.18	89.18	2200.0
2009-05-18 06:15:00	SPY	ETF	89.16	89.16	89.15	89.15	6100.0
2009-05-18 06:20:00	SPY	ETF	89.08	89.08	89.08	89.08	100.0
2009-05-18 06:40:00	SPY	ETF	89.1	89.1	89.1	89.1	300.0
2009-05-18 06:45:00	SPY	ETF	89.03	89.03	89.0	89.01	1200.0
2009-05-18 06:50:00	SPY	ETF	89.04	89.09	89.04	89.09	55400.0
2009-05-18 06:55:00	SPY	ETF	89.13	89.13	89.13	89.13	6000.0
2009-05-18 07:00:00	SPY	ETF	89.11	89.3	89.1	89.29	28700.0
2009-05-18 07:05:00	SPY	ETF	89.26	89.28	89.18	89.18	15390.0
2009-05-18 07:10:00	SPY	ETF	89.18	89.23	89.14	89.23	10600.0
2009-05-18 07:15:00	SPY	ETF	89.19	89.27	89.19	89.27	10800.0
2009-05-18 07:20:00	SPY	ETF	89.27	89.35	89.21	89.26	110208.0
2009-05-18 07:25:00	SPY	ETF	89.27	89.29	89.25	89.26	24280.0
2009-05-18 07:30:00	SPY	ETF	89.29	89.3	89.21	89.21	112100.0
2009-05-18 07:35:00	SPY	ETF	89.2	89.35	89.2	89.32	51400.0
2009-05-18 07:40:00	SPY	ETF	89.32	89.64	89.32	89.59	333932.0
2009-05-18 07:45:00	SPY	ETF	89.59	89.59	89.53	89.54	65974.0
2009-05-18 07:50:00	SPY	ETF	89.55	89.58	89.53	89.54	137860.0
2009-05-18 07:55:00	SPY	ETF	89.52	89.53	89.47	89.48	267977.0
2009-05-18 08:00:00	SPY	ETF	89.47	89.6	88.76	89.55	1327332.0
2009-05-18 08:05:00	SPY	ETF	89.56	89.61	89.5	89.61	267889.0
2009-05-18 08:10:00	SPY	ETF	89.6	89.61	89.42	89.42	237770.0
2009-05-18 08:15:00	SPY	ETF	89.43	89.5	89.37	89.47	487422.0
2009-05-18 08:20:00	SPY	ETF	89.47	89.5	89.46	89.48	170447.0
2009-05-18 08:25:00	SPY	ETF	89.47	89.47	89.36	89.41	102853.0
2009-05-18 08:30:00	SPY	ETF	89.41	89.47	89.34	89.42	169766.0
2009-05-18 08:35:00	SPY	ETF	89.42	89.46	89.41	89.42	83524.0
2009-05-18 08:40:00	SPY	ETF	89.42	89.45	89.32	89.37	216359.0
2009-05-18 08:45:00	SPY	ETF	89.37	89.45	89.36	89.45	84255.0
2009-05-18 08:50:00	SPY	ETF	89.44	89.5	89.44	89.49	233321.0
2009-05-18 08:55:00	SPY	ETF	89.48	89.5	89.42	89.46	91984.0
2009-05-18 09:00:00	SPY	ETF	89.46	89.52	89.46	89.51	115735.0
2009-05-18 09:05:00	SPY	ETF	89.51	89.65	88.4925	89.65	185974.0
2009-05-18 09:10:00	SPY	ETF	89.63	89.63	89.56	89.59	257568.0
2009-05-18 09:15:00	SPY	ETF	89.59	89.64	89.59	89.6	59231.0

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

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