PREVIEW / etf_5min / 2010-01-27

all etf 5-min files

  file:    by_date/etf_5min/2010/2010-01-27.parquet
  size:    815 KB
  rows:    33,277

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-01-27 04:05:00	SPY	ETF	108.97	108.97	108.97	108.97	100.0
2010-01-27 04:10:00	SPY	ETF	108.87	108.87	108.87	108.87	100.0
2010-01-27 04:15:00	SPY	ETF	108.87	108.92	108.82	108.92	865.0
2010-01-27 04:20:00	SPY	ETF	108.95	109.09	108.95	109.09	2500.0
2010-01-27 04:25:00	SPY	ETF	109.09	109.09	109.09	109.09	10000.0
2010-01-27 04:40:00	SPY	ETF	108.98	108.98	108.97	108.97	500.0
2010-01-27 04:50:00	SPY	ETF	108.91	108.91	108.91	108.91	100.0
2010-01-27 04:55:00	SPY	ETF	108.96	108.96	108.96	108.96	100.0
2010-01-27 05:05:00	SPY	ETF	109.12	109.12	109.09	109.09	1600.0
2010-01-27 05:20:00	SPY	ETF	109.22	109.26	109.22	109.26	200.0
2010-01-27 05:35:00	SPY	ETF	109.27	109.27	109.18	109.18	5222.0
2010-01-27 05:40:00	SPY	ETF	109.24	109.25	109.24	109.25	15000.0
2010-01-27 05:45:00	SPY	ETF	109.24	109.24	109.24	109.24	100.0
2010-01-27 05:55:00	SPY	ETF	109.2	109.2	109.12	109.12	700.0
2010-01-27 06:00:00	SPY	ETF	109.15	109.15	109.15	109.15	10155.0
2010-01-27 06:10:00	SPY	ETF	109.25	109.25	109.25	109.25	900.0
2010-01-27 06:40:00	SPY	ETF	109.46	109.55	109.46	109.55	16180.0
2010-01-27 06:50:00	SPY	ETF	109.44	109.44	109.42	109.42	3600.0
2010-01-27 07:00:00	SPY	ETF	109.49	109.49	109.42	109.42	100000.0
2010-01-27 07:05:00	SPY	ETF	109.42	109.46	109.42	109.44	8428.0
2010-01-27 07:10:00	SPY	ETF	109.44	109.46	109.4	109.41	37000.0
2010-01-27 07:15:00	SPY	ETF	109.38	109.52	109.37	109.51	258512.0
2010-01-27 07:20:00	SPY	ETF	109.52	109.57	109.51	109.55	163600.0
2010-01-27 07:25:00	SPY	ETF	109.55	109.55	109.44	109.47	47726.0
2010-01-27 07:30:00	SPY	ETF	109.47	109.55	109.38	109.38	81868.0
2010-01-27 07:35:00	SPY	ETF	109.42	109.42	109.33	109.37	27265.0
2010-01-27 07:40:00	SPY	ETF	109.39	109.39	109.36	109.39	25000.0
2010-01-27 07:45:00	SPY	ETF	109.37	109.4	109.35	109.4	24612.0
2010-01-27 07:50:00	SPY	ETF	109.39	109.39	109.32	109.32	44657.0
2010-01-27 07:55:00	SPY	ETF	109.34	109.38	109.34	109.35	32061.0
2010-01-27 08:00:00	SPY	ETF	109.45	109.55	109.19	109.23	891234.0
2010-01-27 08:05:00	SPY	ETF	109.23	109.27	109.18	109.22	429767.0
2010-01-27 08:10:00	SPY	ETF	109.21	109.31	109.21	109.3	90100.0
2010-01-27 08:15:00	SPY	ETF	109.29	109.38	108.87	109.34	321524.0
2010-01-27 08:20:00	SPY	ETF	109.35	109.38	109.27	109.27	150893.0
2010-01-27 08:25:00	SPY	ETF	109.28	109.38	109.25	109.35	192795.0
2010-01-27 08:30:00	SPY	ETF	109.35	109.36	109.32	109.32	63887.0
2010-01-27 08:35:00	SPY	ETF	109.32	109.34	109.3	109.32	36050.0
2010-01-27 08:40:00	SPY	ETF	109.31	109.4	109.3	109.32	319542.0
2010-01-27 08:45:00	SPY	ETF	109.33	109.34	109.3	109.31	115439.0
2010-01-27 08:50:00	SPY	ETF	109.31	109.33	109.3	109.32	40569.0
2010-01-27 08:55:00	SPY	ETF	109.31	109.31	109.22	109.22	110546.0
2010-01-27 09:00:00	SPY	ETF	109.22	109.22	109.03	109.13	1009219.0
2010-01-27 09:05:00	SPY	ETF	109.11	109.11	108.84	108.88	1395928.0
2010-01-27 09:10:00	SPY	ETF	108.87	109.05	108.83	109.0	1617933.0
2010-01-27 09:15:00	SPY	ETF	109.0	109.06	108.92	109.01	977867.0
2010-01-27 09:20:00	SPY	ETF	109.02	109.17	109.02	109.13	273703.0
2010-01-27 09:25:00	SPY	ETF	109.12	109.18	109.06	109.17	332036.0
2010-01-27 09:30:00	SPY	ETF	109.17	109.28	108.94	109.28	6890300.0
2010-01-27 09:35:00	SPY	ETF	109.27	109.51	109.24	109.45	8239188.0

> showing 50 of 33,277 rows — these rows as CSV

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