PREVIEW / etf_5min / 2009-08-05

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-08-05.parquet
  size:    727 KB
  rows:    30,604

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-08-05 04:15:00	SPY	ETF	100.59	100.66	100.59	100.59	2050.0
2009-08-05 04:20:00	SPY	ETF	100.56	100.56	100.56	100.56	250.0
2009-08-05 04:25:00	SPY	ETF	100.52	100.52	100.51	100.51	550.0
2009-08-05 04:30:00	SPY	ETF	100.62	100.62	100.62	100.62	100.0
2009-08-05 04:35:00	SPY	ETF	100.6	100.6	100.6	100.6	100.0
2009-08-05 05:05:00	SPY	ETF	100.63	100.63	100.63	100.63	2000.0
2009-08-05 05:10:00	SPY	ETF	100.72	100.72	100.72	100.72	100.0
2009-08-05 05:15:00	SPY	ETF	100.78	100.78	100.78	100.78	2000.0
2009-08-05 05:25:00	SPY	ETF	100.79	100.79	100.79	100.79	100.0
2009-08-05 05:30:00	SPY	ETF	100.8	100.82	100.8	100.82	1100.0
2009-08-05 05:35:00	SPY	ETF	100.81	100.86	100.81	100.86	336.0
2009-08-05 06:10:00	SPY	ETF	100.87	100.87	100.87	100.87	300.0
2009-08-05 06:15:00	SPY	ETF	100.92	100.92	100.92	100.92	500.0
2009-08-05 06:20:00	SPY	ETF	100.85	100.85	100.85	100.85	1500.0
2009-08-05 06:35:00	SPY	ETF	100.9	100.9	100.9	100.9	100.0
2009-08-05 06:45:00	SPY	ETF	100.93	100.93	100.93	100.93	226.0
2009-08-05 06:50:00	SPY	ETF	100.99	100.99	100.99	100.99	2000.0
2009-08-05 06:55:00	SPY	ETF	100.95	101.0	100.95	101.0	1200.0
2009-08-05 07:00:00	SPY	ETF	100.98	100.98	100.92	100.92	29826.0
2009-08-05 07:05:00	SPY	ETF	100.87	100.87	100.78	100.86	3660.0
2009-08-05 07:10:00	SPY	ETF	100.85	100.85	100.85	100.85	3500.0
2009-08-05 07:15:00	SPY	ETF	100.8	100.83	100.8	100.82	50900.0
2009-08-05 07:20:00	SPY	ETF	100.78	100.84	100.78	100.83	2000.0
2009-08-05 07:25:00	SPY	ETF	100.86	100.93	100.86	100.93	2531.0
2009-08-05 07:30:00	SPY	ETF	100.96	101.07	100.96	101.03	30899.0
2009-08-05 07:35:00	SPY	ETF	101.03	101.05	100.94	100.95	41211.0
2009-08-05 07:40:00	SPY	ETF	100.88	100.94	100.86	100.89	44900.0
2009-08-05 07:45:00	SPY	ETF	100.89	100.91	100.89	100.91	13500.0
2009-08-05 07:50:00	SPY	ETF	100.9	100.9	100.87	100.87	60500.0
2009-08-05 07:55:00	SPY	ETF	100.87	100.87	100.83	100.84	48970.0
2009-08-05 08:00:00	SPY	ETF	100.86	100.93	100.82	100.92	242685.0
2009-08-05 08:05:00	SPY	ETF	100.92	100.97	100.89	100.96	33765.0
2009-08-05 08:10:00	SPY	ETF	100.95	101.03	100.68	101.03	716478.0
2009-08-05 08:15:00	SPY	ETF	101.02	101.02	100.67	100.81	586146.0
2009-08-05 08:20:00	SPY	ETF	100.82	100.99	100.8	100.82	207754.0
2009-08-05 08:25:00	SPY	ETF	100.83	100.84	100.65	100.68	167500.0
2009-08-05 08:30:00	SPY	ETF	100.67	100.7	100.61	100.62	134351.0
2009-08-05 08:35:00	SPY	ETF	100.61	100.66	100.57	100.58	84362.0
2009-08-05 08:40:00	SPY	ETF	100.58	100.61	100.55	100.59	95485.0
2009-08-05 08:45:00	SPY	ETF	100.59	100.69	100.59	100.63	116872.0
2009-08-05 08:50:00	SPY	ETF	100.63	100.64	100.59	100.6	67216.0
2009-08-05 08:55:00	SPY	ETF	100.59	100.66	100.58	100.66	115197.0
2009-08-05 09:00:00	SPY	ETF	100.67	100.77	100.66	100.75	100386.0
2009-08-05 09:05:00	SPY	ETF	100.75	100.81	100.75	100.81	61612.0
2009-08-05 09:10:00	SPY	ETF	100.82	100.82	100.74	100.8	129387.0
2009-08-05 09:15:00	SPY	ETF	100.8	100.87	100.77	100.83	183980.0
2009-08-05 09:20:00	SPY	ETF	100.83	100.84	100.77	100.78	37647.0
2009-08-05 09:25:00	SPY	ETF	100.77	100.8	100.75	100.77	282669.0
2009-08-05 09:30:00	SPY	ETF	100.77	100.78	100.47	100.52	3635110.0
2009-08-05 09:35:00	SPY	ETF	100.53	100.78	100.49	100.78	4090141.0

> showing 50 of 30,604 rows — these rows as CSV

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