PREVIEW / etf_5min / 2008-01-04

all etf 5-min files

  file:    by_date/etf_5min/2008/2008-01-04.parquet
  size:    476 KB
  rows:    22,819

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
2008-01-04 06:40:00	SPY	ETF	145.31	145.31	145.28	145.28	11000.0
2008-01-04 06:45:00	SPY	ETF	145.28	145.33	145.28	145.33	4000.0
2008-01-04 06:50:00	SPY	ETF	145.29	145.29	145.28	145.28	1000.0
2008-01-04 06:55:00	SPY	ETF	145.26	145.28	145.22	145.28	19000.0
2008-01-04 07:00:00	SPY	ETF	145.28	145.28	145.14	145.14	146700.0
2008-01-04 07:05:00	SPY	ETF	145.05	145.05	145.05	145.05	2000.0
2008-01-04 07:10:00	SPY	ETF	145.05	145.11	145.03	145.03	141600.0
2008-01-04 07:15:00	SPY	ETF	145.0	145.15	145.0	145.15	18500.0
2008-01-04 07:20:00	SPY	ETF	145.15	145.2	145.15	145.17	7900.0
2008-01-04 07:25:00	SPY	ETF	145.17	145.17	145.17	145.17	3100.0
2008-01-04 07:30:00	SPY	ETF	145.18	145.2	145.17	145.17	2300.0
2008-01-04 07:35:00	SPY	ETF	145.17	145.2	145.17	145.2	30800.0
2008-01-04 07:40:00	SPY	ETF	145.2	145.23	145.2	145.23	4100.0
2008-01-04 07:45:00	SPY	ETF	145.2	145.21	145.15	145.16	89700.0
2008-01-04 07:50:00	SPY	ETF	145.16	145.23	145.15	145.23	105800.0
2008-01-04 07:55:00	SPY	ETF	145.21	145.21	145.19	145.19	1100.0
2008-01-04 08:00:00	SPY	ETF	145.2	145.31	145.17	145.31	723000.0
2008-01-04 08:05:00	SPY	ETF	145.28	145.28	145.2	145.22	186400.0
2008-01-04 08:10:00	SPY	ETF	145.22	145.26	144.98	145.17	177400.0
2008-01-04 08:15:00	SPY	ETF	145.14	145.34	145.09	145.16	136500.0
2008-01-04 08:20:00	SPY	ETF	145.15	145.21	145.05	145.05	99600.0
2008-01-04 08:25:00	SPY	ETF	145.02	145.27	144.92	145.22	486500.0
2008-01-04 08:30:00	SPY	ETF	145.22	145.22	143.51	143.73	7099300.0
2008-01-04 08:35:00	SPY	ETF	143.72	143.84	143.54	143.6	1754700.0
2008-01-04 08:40:00	SPY	ETF	143.62	143.68	143.56	143.6	1715600.0
2008-01-04 08:45:00	SPY	ETF	143.6	143.62	143.41	143.6	807300.0
2008-01-04 08:50:00	SPY	ETF	143.59	143.6	143.36	143.4	1103700.0
2008-01-04 08:55:00	SPY	ETF	143.4	143.45	143.28	143.38	1495100.0
2008-01-04 09:00:00	SPY	ETF	143.4	143.43	143.1	143.14	631900.0
2008-01-04 09:05:00	SPY	ETF	143.16	143.24	143.1	143.19	1026200.0
2008-01-04 09:10:00	SPY	ETF	143.2	143.38	143.2	143.34	544600.0
2008-01-04 09:15:00	SPY	ETF	143.32	143.32	143.26	143.29	296300.0
2008-01-04 09:20:00	SPY	ETF	143.27	143.41	143.26	143.26	327200.0
2008-01-04 09:25:00	SPY	ETF	143.27	143.39	143.26	143.34	255655.0
2008-01-04 09:30:00	SPY	ETF	143.34	143.44	143.11	143.16	3977374.0
2008-01-04 09:35:00	SPY	ETF	143.17	143.4299	142.66	142.69	7209328.0
2008-01-04 09:40:00	SPY	ETF	142.69	143.3099	142.69	143.06	3339495.0
2008-01-04 09:45:00	SPY	ETF	143.06	143.1	142.75	142.85	4489298.0
2008-01-04 09:50:00	SPY	ETF	142.85	143.03	142.81	142.83	3256545.0
2008-01-04 09:55:00	SPY	ETF	142.83	142.96	142.7	142.96	2187447.0
2008-01-04 10:00:00	SPY	ETF	142.9584	143.17	142.6	142.82	5139783.0
2008-01-04 10:05:00	SPY	ETF	142.716	143.0	142.716	142.99	2787921.0
2008-01-04 10:10:00	SPY	ETF	142.99	143.01	142.68	142.78	1744637.0
2008-01-04 10:15:00	SPY	ETF	142.78	142.81	142.48	142.5	2096541.0
2008-01-04 10:20:00	SPY	ETF	142.5	142.71	142.46	142.5924	2151133.0
2008-01-04 10:25:00	SPY	ETF	142.59	142.6	142.28	142.36	2171018.0
2008-01-04 10:30:00	SPY	ETF	142.36	142.6	142.22	142.45	2297977.0
2008-01-04 10:35:00	SPY	ETF	142.45	142.55	142.29	142.31	1840445.0
2008-01-04 10:40:00	SPY	ETF	142.32	142.51	142.3	142.38	1588527.0
2008-01-04 10:45:00	SPY	ETF	142.39	142.6	142.05	142.191	2127929.0

> showing 50 of 22,819 rows — these rows as CSV

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