PREVIEW / etf_5min / 2009-07-20

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-20.parquet
  size:    708 KB
  rows:    30,645

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-07-20 04:15:00	SPY	ETF	94.41	94.46	94.41	94.46	1200.0
2009-07-20 04:25:00	SPY	ETF	94.41	94.41	94.41	94.41	100.0
2009-07-20 04:35:00	SPY	ETF	94.38	94.38	94.35	94.37	300.0
2009-07-20 04:45:00	SPY	ETF	94.38	94.38	94.38	94.38	100.0
2009-07-20 04:50:00	SPY	ETF	94.36	94.36	94.36	94.36	100.0
2009-07-20 05:05:00	SPY	ETF	94.46	94.5	94.46	94.5	700.0
2009-07-20 05:10:00	SPY	ETF	94.62	94.66	94.62	94.65	8200.0
2009-07-20 05:15:00	SPY	ETF	94.64	94.73	94.64	94.73	4300.0
2009-07-20 05:20:00	SPY	ETF	94.74	94.83	94.74	94.83	2900.0
2009-07-20 05:30:00	SPY	ETF	94.78	94.78	94.78	94.78	200.0
2009-07-20 05:50:00	SPY	ETF	94.75	94.75	94.75	94.75	600.0
2009-07-20 06:05:00	SPY	ETF	94.8	94.82	94.8	94.82	5600.0
2009-07-20 06:10:00	SPY	ETF	94.82	94.83	94.82	94.82	3800.0
2009-07-20 06:15:00	SPY	ETF	94.81	94.87	94.81	94.87	4400.0
2009-07-20 06:20:00	SPY	ETF	94.86	94.88	94.86	94.88	4400.0
2009-07-20 06:25:00	SPY	ETF	94.89	94.91	94.89	94.91	22600.0
2009-07-20 06:30:00	SPY	ETF	94.86	94.86	94.86	94.86	200.0
2009-07-20 06:35:00	SPY	ETF	94.91	94.91	94.91	94.91	100.0
2009-07-20 06:40:00	SPY	ETF	94.86	94.86	94.85	94.85	10000.0
2009-07-20 06:45:00	SPY	ETF	94.88	94.89	94.83	94.83	25300.0
2009-07-20 06:50:00	SPY	ETF	94.83	94.85	94.82	94.83	168510.0
2009-07-20 06:55:00	SPY	ETF	94.83	94.83	94.76	94.76	113300.0
2009-07-20 07:00:00	SPY	ETF	94.77	94.79	94.72	94.74	35160.0
2009-07-20 07:05:00	SPY	ETF	94.75	94.8	94.75	94.78	16830.0
2009-07-20 07:10:00	SPY	ETF	94.79	94.8	94.76	94.77	41639.0
2009-07-20 07:15:00	SPY	ETF	94.77	94.77	94.71	94.73	87199.0
2009-07-20 07:20:00	SPY	ETF	94.72	94.78	94.69	94.69	38424.0
2009-07-20 07:25:00	SPY	ETF	94.75	94.75	94.73	94.75	52000.0
2009-07-20 07:30:00	SPY	ETF	94.73	94.75	94.67	94.74	11200.0
2009-07-20 07:35:00	SPY	ETF	94.75	94.8	94.74	94.75	21800.0
2009-07-20 07:40:00	SPY	ETF	94.73	94.8	94.72	94.79	94942.0
2009-07-20 07:45:00	SPY	ETF	94.79	94.81	94.74	94.81	31300.0
2009-07-20 07:50:00	SPY	ETF	94.8	94.83	94.79	94.83	88301.0
2009-07-20 07:55:00	SPY	ETF	94.82	94.82	94.69	94.73	45813.0
2009-07-20 08:00:00	SPY	ETF	94.72	94.77	94.71	94.77	50240.0
2009-07-20 08:05:00	SPY	ETF	94.77	94.81	94.76	94.76	57476.0
2009-07-20 08:10:00	SPY	ETF	94.77	94.78	94.68	94.71	122931.0
2009-07-20 08:15:00	SPY	ETF	94.72	94.72	94.68	94.69	26827.0
2009-07-20 08:20:00	SPY	ETF	94.68	94.69	94.65	94.68	96749.0
2009-07-20 08:25:00	SPY	ETF	94.68	94.69	94.58	94.58	90309.0
2009-07-20 08:30:00	SPY	ETF	94.59	94.61	94.55	94.61	113948.0
2009-07-20 08:35:00	SPY	ETF	94.61	94.66	94.57	94.6	145419.0
2009-07-20 08:40:00	SPY	ETF	94.6	94.62	94.58	94.61	513412.0
2009-07-20 08:45:00	SPY	ETF	94.61	94.69	94.61	94.69	162659.0
2009-07-20 08:50:00	SPY	ETF	94.69	94.73	94.63	94.72	366513.0
2009-07-20 08:55:00	SPY	ETF	94.72	94.98	94.67	94.7	152497.0
2009-07-20 09:00:00	SPY	ETF	94.71	94.83	94.7	94.76	678754.0
2009-07-20 09:05:00	SPY	ETF	94.76	94.81	94.76	94.8	109721.0
2009-07-20 09:10:00	SPY	ETF	94.8	94.84	94.78	94.84	168173.0
2009-07-20 09:15:00	SPY	ETF	94.83	94.83	94.75	94.75	104989.0

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

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