PREVIEW / etf_5min / 2009-08-04

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-08-04.parquet
  size:    749 KB
  rows:    31,701

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-04 04:15:00	SPY	ETF	99.98	99.98	99.94	99.94	1500.0
2009-08-04 04:25:00	SPY	ETF	99.94	99.94	99.93	99.93	200.0
2009-08-04 04:35:00	SPY	ETF	99.86	99.86	99.86	99.86	300.0
2009-08-04 04:45:00	SPY	ETF	99.85	99.85	99.84	99.84	600.0
2009-08-04 04:55:00	SPY	ETF	99.81	99.81	99.74	99.76	1239.0
2009-08-04 05:00:00	SPY	ETF	99.73	99.73	99.73	99.73	260.0
2009-08-04 05:05:00	SPY	ETF	99.68	99.68	99.68	99.68	2000.0
2009-08-04 05:10:00	SPY	ETF	99.81	99.81	99.81	99.81	1000.0
2009-08-04 05:20:00	SPY	ETF	99.84	99.85	99.84	99.85	200.0
2009-08-04 05:25:00	SPY	ETF	99.91	99.91	99.91	99.91	300.0
2009-08-04 05:40:00	SPY	ETF	99.84	99.84	99.84	99.84	100.0
2009-08-04 05:45:00	SPY	ETF	99.87	99.87	99.87	99.87	2000.0
2009-08-04 05:55:00	SPY	ETF	99.91	99.91	99.91	99.91	10000.0
2009-08-04 06:00:00	SPY	ETF	99.82	99.82	99.82	99.82	100.0
2009-08-04 06:05:00	SPY	ETF	99.79	99.79	99.78	99.79	6828.0
2009-08-04 06:10:00	SPY	ETF	99.78	99.78	99.74	99.74	600.0
2009-08-04 06:20:00	SPY	ETF	99.76	99.78	99.76	99.78	600.0
2009-08-04 06:25:00	SPY	ETF	99.75	99.83	99.75	99.83	5328.0
2009-08-04 06:30:00	SPY	ETF	99.83	99.83	99.83	99.83	2000.0
2009-08-04 06:35:00	SPY	ETF	99.84	99.84	99.84	99.84	1100.0
2009-08-04 06:40:00	SPY	ETF	99.81	99.81	99.78	99.78	15100.0
2009-08-04 06:45:00	SPY	ETF	99.88	99.88	99.82	99.82	5200.0
2009-08-04 06:50:00	SPY	ETF	99.78	99.78	99.77	99.77	738.0
2009-08-04 06:55:00	SPY	ETF	99.77	99.77	99.75	99.76	25200.0
2009-08-04 07:00:00	SPY	ETF	99.74	99.84	99.74	99.82	34572.0
2009-08-04 07:05:00	SPY	ETF	99.81	99.82	99.75	99.75	3867.0
2009-08-04 07:10:00	SPY	ETF	99.76	99.84	99.76	99.84	111212.0
2009-08-04 07:15:00	SPY	ETF	99.84	99.88	99.83	99.84	13067.0
2009-08-04 07:20:00	SPY	ETF	99.84	99.84	99.74	99.74	58000.0
2009-08-04 07:25:00	SPY	ETF	99.74	99.74	99.71	99.71	25373.0
2009-08-04 07:30:00	SPY	ETF	99.71	99.77	99.71	99.77	89921.0
2009-08-04 07:35:00	SPY	ETF	99.78	99.84	99.78	99.79	42466.0
2009-08-04 07:40:00	SPY	ETF	99.79	99.79	99.76	99.77	36433.0
2009-08-04 07:45:00	SPY	ETF	99.8	99.8	99.79	99.8	17850.0
2009-08-04 07:50:00	SPY	ETF	99.79	99.79	99.75	99.77	132666.0
2009-08-04 07:55:00	SPY	ETF	99.77	99.77	99.74	99.75	44649.0
2009-08-04 08:00:00	SPY	ETF	99.77	99.84	99.71	99.74	107268.0
2009-08-04 08:05:00	SPY	ETF	99.74	99.8	99.74	99.77	69937.0
2009-08-04 08:10:00	SPY	ETF	99.76	99.88	99.76	99.85	71279.0
2009-08-04 08:15:00	SPY	ETF	99.83	99.91	99.83	99.91	60226.0
2009-08-04 08:20:00	SPY	ETF	99.91	99.92	99.83	99.83	71410.0
2009-08-04 08:25:00	SPY	ETF	99.84	99.85	99.73	99.83	185190.0
2009-08-04 08:30:00	SPY	ETF	99.81	99.93	99.69	99.91	317326.0
2009-08-04 08:35:00	SPY	ETF	99.9	100.03	99.83	99.88	134525.0
2009-08-04 08:40:00	SPY	ETF	99.88	99.88	99.8	99.8	99805.0
2009-08-04 08:45:00	SPY	ETF	99.82	99.88	99.8	99.82	211498.0
2009-08-04 08:50:00	SPY	ETF	99.82	99.86	99.8	99.86	69147.0
2009-08-04 08:55:00	SPY	ETF	99.85	99.91	99.8	99.8	95895.0
2009-08-04 09:00:00	SPY	ETF	99.81	99.99	99.81	99.95	140894.0
2009-08-04 09:05:00	SPY	ETF	99.95	100.0	99.95	99.99	148190.0

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

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