PREVIEW / etf_5min / 2009-03-20

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-03-20.parquet
  size:    666 KB
  rows:    28,125

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-03-20 04:15:00	SPY	ETF	77.85	77.85	77.85	77.85	2200.0
2009-03-20 04:25:00	SPY	ETF	77.82	77.82	77.82	77.82	200.0
2009-03-20 04:30:00	SPY	ETF	77.85	77.85	77.85	77.85	200.0
2009-03-20 04:40:00	SPY	ETF	77.81	77.81	77.81	77.81	100.0
2009-03-20 05:10:00	SPY	ETF	77.8	77.8	77.75	77.75	1525.0
2009-03-20 05:15:00	SPY	ETF	77.75	77.75	77.75	77.75	100.0
2009-03-20 05:20:00	SPY	ETF	77.75	77.75	77.75	77.75	1500.0
2009-03-20 05:30:00	SPY	ETF	77.75	77.75	77.75	77.75	100.0
2009-03-20 05:40:00	SPY	ETF	77.65	77.65	77.6	77.6	2600.0
2009-03-20 05:45:00	SPY	ETF	77.58	77.58	77.58	77.58	10000.0
2009-03-20 05:55:00	SPY	ETF	77.73	77.81	77.73	77.75	10400.0
2009-03-20 06:05:00	SPY	ETF	77.64	77.64	77.64	77.64	100.0
2009-03-20 06:10:00	SPY	ETF	77.55	77.57	77.52	77.52	11900.0
2009-03-20 06:15:00	SPY	ETF	77.51	77.64	77.51	77.64	200.0
2009-03-20 06:20:00	SPY	ETF	77.67	77.74	77.67	77.74	500.0
2009-03-20 06:25:00	SPY	ETF	77.7	77.7	77.7	77.7	100.0
2009-03-20 06:30:00	SPY	ETF	77.67	77.74	77.64	77.74	700.0
2009-03-20 06:40:00	SPY	ETF	77.72	77.85	77.67	77.85	1500.0
2009-03-20 06:45:00	SPY	ETF	77.71	77.71	77.67	77.67	1600.0
2009-03-20 06:50:00	SPY	ETF	77.68	77.95	77.68	77.92	5700.0
2009-03-20 06:55:00	SPY	ETF	77.92	78.12	77.92	78.12	12475.0
2009-03-20 07:00:00	SPY	ETF	78.14	78.16	78.1	78.1	3300.0
2009-03-20 07:05:00	SPY	ETF	78.08	78.28	78.08	78.23	38200.0
2009-03-20 07:10:00	SPY	ETF	78.18	78.27	78.17	78.19	90507.0
2009-03-20 07:15:00	SPY	ETF	78.19	78.21	78.16	78.2	6500.0
2009-03-20 07:20:00	SPY	ETF	78.18	78.22	78.13	78.22	18200.0
2009-03-20 07:25:00	SPY	ETF	78.24	78.41	78.24	78.4	30619.0
2009-03-20 07:30:00	SPY	ETF	78.41	78.41	78.25	78.25	60992.0
2009-03-20 07:35:00	SPY	ETF	78.22	78.31	78.17	78.3	60650.0
2009-03-20 07:40:00	SPY	ETF	78.31	78.39	78.3	78.38	23750.0
2009-03-20 07:45:00	SPY	ETF	78.35	78.65	78.33	78.55	135657.0
2009-03-20 07:50:00	SPY	ETF	78.49	78.59	78.49	78.54	47750.0
2009-03-20 07:55:00	SPY	ETF	78.54	78.59	78.47	78.57	82200.0
2009-03-20 08:00:00	SPY	ETF	78.58	78.67	78.23	78.61	559530.0
2009-03-20 08:05:00	SPY	ETF	78.6	78.6	78.48	78.58	120428.0
2009-03-20 08:10:00	SPY	ETF	78.56	78.56	78.05	78.5	98345.0
2009-03-20 08:15:00	SPY	ETF	78.48	78.52	78.36	78.4	336545.0
2009-03-20 08:20:00	SPY	ETF	78.41	78.66	77.72	78.63	121351.0
2009-03-20 08:25:00	SPY	ETF	78.63	78.63	78.56	78.6	108556.0
2009-03-20 08:30:00	SPY	ETF	78.63	78.74	78.63	78.74	201612.0
2009-03-20 08:35:00	SPY	ETF	78.73	78.81	78.71	78.79	480440.0
2009-03-20 08:40:00	SPY	ETF	78.79	78.83	78.74	78.75	740274.0
2009-03-20 08:45:00	SPY	ETF	78.74	78.78	78.68	78.71	281958.0
2009-03-20 08:50:00	SPY	ETF	78.71	78.71	78.58	78.66	75521.0
2009-03-20 08:55:00	SPY	ETF	78.66	78.75	78.64	78.73	296128.0
2009-03-20 09:00:00	SPY	ETF	78.72	78.83	78.71	78.82	237463.0
2009-03-20 09:05:00	SPY	ETF	78.81	78.9	78.77	78.8	426363.0
2009-03-20 09:10:00	SPY	ETF	78.8	78.84	78.72	78.73	280117.0
2009-03-20 09:15:00	SPY	ETF	78.73	78.75	78.58	78.62	489663.0
2009-03-20 09:20:00	SPY	ETF	78.62	78.7	78.62	78.63	463519.0

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

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