PREVIEW / etf_5min / 2009-04-01

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-04-01.parquet
  size:    656 KB
  rows:    28,029

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-04-01 04:15:00	SPY	ETF	78.78	78.78	78.75	78.75	200.0
2009-04-01 04:25:00	SPY	ETF	78.88	78.88	78.88	78.88	200.0
2009-04-01 04:35:00	SPY	ETF	78.84	78.84	78.84	78.84	3100.0
2009-04-01 05:00:00	SPY	ETF	78.9	78.93	78.9	78.93	25000.0
2009-04-01 05:15:00	SPY	ETF	79.02	79.09	79.02	79.09	1000.0
2009-04-01 05:25:00	SPY	ETF	79.15	79.15	79.15	79.15	500.0
2009-04-01 05:50:00	SPY	ETF	79.06	79.06	79.06	79.06	1000.0
2009-04-01 06:10:00	SPY	ETF	79.19	79.2	79.19	79.2	10000.0
2009-04-01 06:20:00	SPY	ETF	79.22	79.22	79.22	79.22	10000.0
2009-04-01 06:30:00	SPY	ETF	79.15	79.15	79.15	79.15	1000.0
2009-04-01 06:40:00	SPY	ETF	79.08	79.08	79.08	79.08	2800.0
2009-04-01 06:55:00	SPY	ETF	79.05	79.05	79.05	79.05	200.0
2009-04-01 07:00:00	SPY	ETF	79.05	79.22	79.05	79.22	267100.0
2009-04-01 07:05:00	SPY	ETF	79.23	79.28	79.23	79.28	83025.0
2009-04-01 07:10:00	SPY	ETF	79.28	79.28	79.17	79.19	29200.0
2009-04-01 07:15:00	SPY	ETF	79.19	79.19	79.13	79.19	36000.0
2009-04-01 07:20:00	SPY	ETF	79.24	79.31	79.21	79.31	44425.0
2009-04-01 07:25:00	SPY	ETF	79.34	79.44	79.34	79.38	183225.0
2009-04-01 07:30:00	SPY	ETF	79.4	79.55	79.4	79.5	84800.0
2009-04-01 07:35:00	SPY	ETF	79.51	79.55	79.43	79.43	125950.0
2009-04-01 07:40:00	SPY	ETF	79.42	79.44	79.39	79.4	41795.0
2009-04-01 07:45:00	SPY	ETF	79.38	79.38	79.24	79.27	28100.0
2009-04-01 07:50:00	SPY	ETF	79.24	79.26	79.16	79.2	70819.0
2009-04-01 07:55:00	SPY	ETF	79.19	79.19	79.13	79.14	49064.0
2009-04-01 08:00:00	SPY	ETF	79.14	79.34	79.14	79.16	1248119.0
2009-04-01 08:05:00	SPY	ETF	79.17	79.19	79.11	79.18	108687.0
2009-04-01 08:10:00	SPY	ETF	79.19	79.37	79.17	79.35	132580.0
2009-04-01 08:15:00	SPY	ETF	79.34	79.34	78.78	78.86	1322346.0
2009-04-01 08:20:00	SPY	ETF	78.86	78.95	78.82	78.82	680297.0
2009-04-01 08:25:00	SPY	ETF	78.82	79.52	78.74	78.74	242076.0
2009-04-01 08:30:00	SPY	ETF	78.74	79.135	78.72	78.79	873883.0
2009-04-01 08:35:00	SPY	ETF	78.79	79.03	78.4	78.93	386118.0
2009-04-01 08:40:00	SPY	ETF	78.93	78.96	78.9	78.92	59080.0
2009-04-01 08:45:00	SPY	ETF	78.92	78.92	78.77	78.77	139287.0
2009-04-01 08:50:00	SPY	ETF	78.77	79.52	78.75	78.86	232336.0
2009-04-01 08:55:00	SPY	ETF	78.85	78.85	78.75	78.82	218898.0
2009-04-01 09:00:00	SPY	ETF	78.8	78.89	78.77	78.88	451079.0
2009-04-01 09:05:00	SPY	ETF	78.88	79.22	78.85	78.87	360744.0
2009-04-01 09:10:00	SPY	ETF	78.88	78.9	78.77	78.78	93732.0
2009-04-01 09:15:00	SPY	ETF	78.76	78.77	78.63	78.64	239498.0
2009-04-01 09:20:00	SPY	ETF	78.65	78.68	78.61	78.65	205227.0
2009-04-01 09:25:00	SPY	ETF	78.64	78.66	78.53	78.54	828163.0
2009-04-01 09:30:00	SPY	ETF	78.53	78.66	78.34	78.35	7003618.0
2009-04-01 09:35:00	SPY	ETF	78.34	78.68	78.33	78.6	8241868.0
2009-04-01 09:40:00	SPY	ETF	78.6	78.725	78.53	78.58	5357602.0
2009-04-01 09:45:00	SPY	ETF	78.58	78.72	78.47	78.49	3579126.0
2009-04-01 09:50:00	SPY	ETF	78.49	78.6	78.47	78.56	3184776.0
2009-04-01 09:55:00	SPY	ETF	78.56	78.9	78.52	78.9	4184653.0
2009-04-01 10:00:00	SPY	ETF	78.8901	79.34	78.8901	79.24	9285265.0
2009-04-01 10:05:00	SPY	ETF	79.24	79.36	79.1	79.29	5674210.0

> showing 50 of 28,029 rows — these rows as CSV

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