PREVIEW / etf_5min / 2009-10-02

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-10-02.parquet
  size:    730 KB
  rows:    30,798

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-10-02 04:15:00	SPY	ETF	102.95	103.01	102.95	103.0	1300.0
2009-10-02 04:20:00	SPY	ETF	102.96	102.96	102.91	102.91	2500.0
2009-10-02 04:25:00	SPY	ETF	102.91	102.93	102.88	102.88	3300.0
2009-10-02 04:30:00	SPY	ETF	102.88	102.88	102.88	102.88	500.0
2009-10-02 04:35:00	SPY	ETF	102.9	102.96	102.9	102.96	200.0
2009-10-02 04:40:00	SPY	ETF	102.93	102.93	102.91	102.91	200.0
2009-10-02 04:45:00	SPY	ETF	102.93	102.93	102.86	102.86	1600.0
2009-10-02 04:50:00	SPY	ETF	103.03	103.03	103.03	103.03	100.0
2009-10-02 05:05:00	SPY	ETF	103.12	103.15	103.12	103.15	300.0
2009-10-02 05:10:00	SPY	ETF	103.14	103.15	103.14	103.15	300.0
2009-10-02 05:20:00	SPY	ETF	103.05	103.05	102.98	102.98	1600.0
2009-10-02 05:25:00	SPY	ETF	103.01	103.01	103.01	103.01	100.0
2009-10-02 05:40:00	SPY	ETF	102.9	102.9	102.9	102.9	2000.0
2009-10-02 05:50:00	SPY	ETF	102.88	102.88	102.85	102.85	2200.0
2009-10-02 06:10:00	SPY	ETF	102.9	102.9	102.89	102.89	200.0
2009-10-02 06:15:00	SPY	ETF	102.92	102.92	102.92	102.92	246.0
2009-10-02 06:20:00	SPY	ETF	102.92	102.94	102.92	102.93	5954.0
2009-10-02 06:25:00	SPY	ETF	102.91	102.91	102.9	102.9	400.0
2009-10-02 06:35:00	SPY	ETF	102.95	102.95	102.95	102.95	10000.0
2009-10-02 06:45:00	SPY	ETF	102.95	102.95	102.95	102.95	3000.0
2009-10-02 06:50:00	SPY	ETF	102.85	102.85	102.85	102.85	200.0
2009-10-02 06:55:00	SPY	ETF	102.85	102.86	102.85	102.86	3800.0
2009-10-02 07:00:00	SPY	ETF	102.87	102.87	102.82	102.87	8325.0
2009-10-02 07:05:00	SPY	ETF	102.88	102.91	102.87	102.88	6733.0
2009-10-02 07:10:00	SPY	ETF	102.91	102.96	102.91	102.96	9260.0
2009-10-02 07:15:00	SPY	ETF	102.94	102.97	102.94	102.96	16506.0
2009-10-02 07:20:00	SPY	ETF	102.97	102.97	102.86	102.89	28500.0
2009-10-02 07:25:00	SPY	ETF	102.87	102.91	102.81	102.81	33997.0
2009-10-02 07:30:00	SPY	ETF	102.86	102.94	102.86	102.94	29495.0
2009-10-02 07:35:00	SPY	ETF	102.92	102.94	102.92	102.94	5702.0
2009-10-02 07:40:00	SPY	ETF	102.92	102.92	102.9	102.92	79000.0
2009-10-02 07:45:00	SPY	ETF	102.97	103.02	102.96	103.0	20425.0
2009-10-02 07:50:00	SPY	ETF	102.99	102.99	102.95	102.95	4643.0
2009-10-02 07:55:00	SPY	ETF	102.95	103.03	102.95	102.98	81495.0
2009-10-02 08:00:00	SPY	ETF	102.94	102.98	102.86	102.9	93072.0
2009-10-02 08:05:00	SPY	ETF	102.91	102.92	102.84	102.86	103191.0
2009-10-02 08:10:00	SPY	ETF	102.86	103.11	102.83	102.87	172982.0
2009-10-02 08:15:00	SPY	ETF	102.87	102.88	102.8	102.82	306277.0
2009-10-02 08:20:00	SPY	ETF	102.82	102.84	102.75	102.81	548761.0
2009-10-02 08:25:00	SPY	ETF	102.82	102.98	102.66	102.88	658098.0
2009-10-02 08:30:00	SPY	ETF	102.66	102.85	101.98	102.2	4997012.0
2009-10-02 08:35:00	SPY	ETF	102.2	102.3	101.82	102.04	3232422.0
2009-10-02 08:40:00	SPY	ETF	102.04	102.15	101.97	102.11	717790.0
2009-10-02 08:45:00	SPY	ETF	102.1	102.15	102.02	102.03	773382.0
2009-10-02 08:50:00	SPY	ETF	102.03	102.07	101.75	101.8	1696040.0
2009-10-02 08:55:00	SPY	ETF	101.81	101.92	101.76	101.82	1201800.0
2009-10-02 09:00:00	SPY	ETF	101.82	101.83	101.7	101.75	962601.0
2009-10-02 09:05:00	SPY	ETF	101.75	101.82	101.68	101.77	1154078.0
2009-10-02 09:10:00	SPY	ETF	101.75	102.0	101.75	102.0	673566.0
2009-10-02 09:15:00	SPY	ETF	101.99	102.12	101.98	102.12	710926.0

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

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