PREVIEW / etf_5min / 2009-03-03

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-03-03.parquet
  size:    726 KB
  rows:    31,092

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-03 04:15:00	SPY	ETF	71.87	71.93	71.87	71.93	1300.0
2009-03-03 04:20:00	SPY	ETF	71.87	71.87	71.87	71.87	1500.0
2009-03-03 04:25:00	SPY	ETF	71.8	71.8	71.8	71.8	100.0
2009-03-03 04:30:00	SPY	ETF	71.62	71.62	71.62	71.62	200.0
2009-03-03 04:35:00	SPY	ETF	71.51	71.51	71.48	71.48	1300.0
2009-03-03 04:55:00	SPY	ETF	71.28	71.28	71.28	71.28	100.0
2009-03-03 05:00:00	SPY	ETF	71.31	71.33	71.21	71.21	2300.0
2009-03-03 05:05:00	SPY	ETF	71.24	71.24	71.2	71.2	632.0
2009-03-03 05:15:00	SPY	ETF	71.27	71.27	71.27	71.27	480.0
2009-03-03 05:20:00	SPY	ETF	71.27	71.27	71.27	71.27	500.0
2009-03-03 05:30:00	SPY	ETF	71.14	71.14	71.14	71.14	300.0
2009-03-03 05:35:00	SPY	ETF	71.17	71.19	71.17	71.19	400.0
2009-03-03 05:40:00	SPY	ETF	71.2	71.24	71.2	71.24	300.0
2009-03-03 05:55:00	SPY	ETF	71.33	71.36	71.33	71.35	15000.0
2009-03-03 06:10:00	SPY	ETF	71.4	71.4	71.32	71.32	5300.0
2009-03-03 06:20:00	SPY	ETF	71.25	71.25	71.25	71.25	1500.0
2009-03-03 06:25:00	SPY	ETF	71.33	71.33	71.2	71.2	2000.0
2009-03-03 06:30:00	SPY	ETF	71.19	71.19	70.89	70.89	4900.0
2009-03-03 06:35:00	SPY	ETF	71.03	71.15	70.98	71.07	10362.0
2009-03-03 06:40:00	SPY	ETF	71.07	71.15	71.07	71.15	2200.0
2009-03-03 06:45:00	SPY	ETF	71.1	71.1	70.92	70.92	18200.0
2009-03-03 06:50:00	SPY	ETF	70.95	71.0	70.95	71.0	4200.0
2009-03-03 06:55:00	SPY	ETF	71.0	71.05	71.0	71.05	1200.0
2009-03-03 07:00:00	SPY	ETF	71.1	71.33	71.1	71.33	140972.0
2009-03-03 07:05:00	SPY	ETF	71.33	71.33	71.22	71.29	32800.0
2009-03-03 07:10:00	SPY	ETF	71.31	71.39	71.31	71.39	125800.0
2009-03-03 07:15:00	SPY	ETF	71.4	71.56	71.39	71.49	66800.0
2009-03-03 07:20:00	SPY	ETF	71.4	71.6	71.39	71.6	762910.0
2009-03-03 07:25:00	SPY	ETF	71.63	71.63	71.43	71.43	77700.0
2009-03-03 07:30:00	SPY	ETF	71.46	71.46	71.33	71.35	51321.0
2009-03-03 07:35:00	SPY	ETF	71.35	71.38	71.31	71.33	17676.0
2009-03-03 07:40:00	SPY	ETF	71.37	71.45	71.34	71.4	113700.0
2009-03-03 07:45:00	SPY	ETF	71.38	71.5	71.37	71.5	189909.0
2009-03-03 07:50:00	SPY	ETF	71.5	71.58	71.33	71.34	280650.0
2009-03-03 07:55:00	SPY	ETF	71.32	71.38	71.27	71.27	59678.0
2009-03-03 08:00:00	SPY	ETF	72.05	72.05	71.2	71.29	1083928.0
2009-03-03 08:05:00	SPY	ETF	71.27	71.36	71.25	71.32	113108.0
2009-03-03 08:10:00	SPY	ETF	71.31	71.44	71.29	71.33	126618.0
2009-03-03 08:15:00	SPY	ETF	71.31	71.6	71.31	71.6	258590.0
2009-03-03 08:20:00	SPY	ETF	71.59	71.82	71.58	71.81	468456.0
2009-03-03 08:25:00	SPY	ETF	71.78	71.84	71.7	71.74	594166.0
2009-03-03 08:30:00	SPY	ETF	71.75	71.82	71.64	71.81	254167.0
2009-03-03 08:35:00	SPY	ETF	71.81	71.93	71.81	71.91	341216.0
2009-03-03 08:40:00	SPY	ETF	71.9	71.92	71.82	71.84	200733.0
2009-03-03 08:45:00	SPY	ETF	71.83	71.83	71.64	71.64	1096573.0
2009-03-03 08:50:00	SPY	ETF	71.64	71.66	71.59	71.64	218337.0
2009-03-03 08:55:00	SPY	ETF	71.64	71.77	71.63	71.74	201929.0
2009-03-03 09:00:00	SPY	ETF	71.74	71.78	71.67	71.68	347926.0
2009-03-03 09:05:00	SPY	ETF	71.68	71.76	71.63	71.64	197929.0
2009-03-03 09:10:00	SPY	ETF	71.63	71.76	71.57	71.76	155668.0

> showing 50 of 31,092 rows — these rows as CSV

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