PREVIEW / etf_5min / 2009-08-03

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-08-03.parquet
  size:    763 KB
  rows:    32,286

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-03 04:00:00	SPY	ETF	99.22	99.22	99.22	99.22	300.0
2009-08-03 04:15:00	SPY	ETF	99.28	99.61	99.28	99.61	4592.0
2009-08-03 04:20:00	SPY	ETF	99.51	99.52	99.51	99.52	600.0
2009-08-03 04:25:00	SPY	ETF	99.59	99.61	99.59	99.61	2600.0
2009-08-03 04:30:00	SPY	ETF	99.61	99.64	99.61	99.64	4100.0
2009-08-03 04:35:00	SPY	ETF	99.64	99.67	99.64	99.67	9100.0
2009-08-03 04:40:00	SPY	ETF	99.64	99.64	99.64	99.64	400.0
2009-08-03 04:55:00	SPY	ETF	99.7	99.77	99.7	99.77	5700.0
2009-08-03 05:15:00	SPY	ETF	99.72	99.72	99.72	99.72	100.0
2009-08-03 05:20:00	SPY	ETF	99.68	99.68	99.68	99.68	200.0
2009-08-03 05:30:00	SPY	ETF	99.81	100.01	99.81	100.01	23900.0
2009-08-03 05:35:00	SPY	ETF	99.95	99.95	99.95	99.95	200.0
2009-08-03 05:40:00	SPY	ETF	99.99	99.99	99.99	99.99	5000.0
2009-08-03 05:50:00	SPY	ETF	100.0	100.0	100.0	100.0	2500.0
2009-08-03 05:55:00	SPY	ETF	100.08	100.08	100.0	100.0	8600.0
2009-08-03 06:00:00	SPY	ETF	100.05	100.09	100.05	100.09	600.0
2009-08-03 06:05:00	SPY	ETF	100.02	100.02	100.02	100.02	2500.0
2009-08-03 06:15:00	SPY	ETF	100.03	100.03	100.03	100.03	1750.0
2009-08-03 06:20:00	SPY	ETF	100.0	100.02	100.0	100.02	600.0
2009-08-03 06:25:00	SPY	ETF	100.02	100.02	100.02	100.02	2400.0
2009-08-03 06:30:00	SPY	ETF	100.0	100.0	100.0	100.0	600.0
2009-08-03 06:35:00	SPY	ETF	100.04	100.04	100.04	100.04	300.0
2009-08-03 06:40:00	SPY	ETF	99.98	100.07	99.94	100.06	23408.0
2009-08-03 06:45:00	SPY	ETF	100.04	100.05	100.02	100.03	16000.0
2009-08-03 06:50:00	SPY	ETF	99.97	99.97	99.94	99.97	967.0
2009-08-03 06:55:00	SPY	ETF	99.91	99.91	99.84	99.86	23300.0
2009-08-03 07:00:00	SPY	ETF	99.87	99.9	99.84	99.89	2493.0
2009-08-03 07:05:00	SPY	ETF	99.85	99.9	99.84	99.86	19900.0
2009-08-03 07:10:00	SPY	ETF	99.86	99.87	99.83	99.86	29900.0
2009-08-03 07:15:00	SPY	ETF	99.9	99.91	99.83	99.85	5350.0
2009-08-03 07:20:00	SPY	ETF	99.84	99.91	99.8	99.9	16506.0
2009-08-03 07:25:00	SPY	ETF	99.91	99.91	99.85	99.85	17000.0
2009-08-03 07:30:00	SPY	ETF	99.85	99.85	99.8	99.8	7930.0
2009-08-03 07:35:00	SPY	ETF	99.79	99.81	99.79	99.79	30499.0
2009-08-03 07:40:00	SPY	ETF	99.8	99.87	99.8	99.87	7575.0
2009-08-03 07:45:00	SPY	ETF	99.87	99.88	99.8	99.83	18498.0
2009-08-03 07:50:00	SPY	ETF	99.8	99.83	99.8	99.83	55200.0
2009-08-03 07:55:00	SPY	ETF	99.83	99.89	99.82	99.89	43495.0
2009-08-03 08:00:00	SPY	ETF	99.87	100.19	98.82	99.77	622376.0
2009-08-03 08:05:00	SPY	ETF	99.77	99.79	99.73	99.75	37388.0
2009-08-03 08:10:00	SPY	ETF	99.76	99.81	99.76	99.78	147857.0
2009-08-03 08:15:00	SPY	ETF	99.78	99.86	99.76	99.82	209578.0
2009-08-03 08:20:00	SPY	ETF	99.82	99.88	99.8	99.88	126560.0
2009-08-03 08:25:00	SPY	ETF	99.88	99.93	99.87	99.89	125072.0
2009-08-03 08:30:00	SPY	ETF	99.89	99.91	99.85	99.86	365117.0
2009-08-03 08:35:00	SPY	ETF	99.86	99.91	99.8	99.91	158953.0
2009-08-03 08:40:00	SPY	ETF	99.92	99.93	99.84	99.84	62873.0
2009-08-03 08:45:00	SPY	ETF	99.84	99.87	99.81	99.82	76712.0
2009-08-03 08:50:00	SPY	ETF	99.81	99.86	99.74	99.75	94384.0
2009-08-03 08:55:00	SPY	ETF	99.75	99.82	99.74	99.82	43468.0

> showing 50 of 32,286 rows — these rows as CSV

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