PREVIEW / etf_5min / 2009-11-17

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-11-17.parquet
  size:    725 KB
  rows:    31,273

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-11-17 04:25:00	SPY	ETF	110.93	110.93	110.93	110.93	100.0
2009-11-17 04:40:00	SPY	ETF	111.01	111.02	111.01	111.02	600.0
2009-11-17 05:15:00	SPY	ETF	110.96	110.96	110.96	110.96	500.0
2009-11-17 05:20:00	SPY	ETF	110.97	110.97	110.97	110.97	1000.0
2009-11-17 05:35:00	SPY	ETF	111.0	111.0	111.0	111.0	100.0
2009-11-17 05:40:00	SPY	ETF	111.0	111.01	111.0	111.01	200.0
2009-11-17 06:00:00	SPY	ETF	110.95	110.98	110.95	110.98	15000.0
2009-11-17 06:05:00	SPY	ETF	110.87	110.87	110.84	110.87	17300.0
2009-11-17 06:10:00	SPY	ETF	110.91	110.91	110.86	110.86	6300.0
2009-11-17 06:30:00	SPY	ETF	111.01	111.01	110.99	110.99	5000.0
2009-11-17 06:35:00	SPY	ETF	111.07	111.07	111.07	111.07	7500.0
2009-11-17 06:40:00	SPY	ETF	111.07	111.07	111.07	111.07	500.0
2009-11-17 06:45:00	SPY	ETF	111.07	111.07	111.07	111.07	100.0
2009-11-17 07:00:00	SPY	ETF	111.04	111.04	110.97	110.97	2500.0
2009-11-17 07:05:00	SPY	ETF	110.96	110.96	110.89	110.89	6300.0
2009-11-17 07:10:00	SPY	ETF	110.89	110.92	110.89	110.91	9300.0
2009-11-17 07:15:00	SPY	ETF	110.9	110.92	110.75	110.78	57491.0
2009-11-17 07:20:00	SPY	ETF	110.76	110.76	110.65	110.71	48817.0
2009-11-17 07:25:00	SPY	ETF	110.73	110.78	110.73	110.76	7454.0
2009-11-17 07:30:00	SPY	ETF	110.76	110.76	110.7	110.72	17561.0
2009-11-17 07:35:00	SPY	ETF	110.73	110.73	110.7	110.7	9490.0
2009-11-17 07:40:00	SPY	ETF	110.68	110.74	110.68	110.74	4700.0
2009-11-17 07:45:00	SPY	ETF	110.69	110.82	110.69	110.82	6900.0
2009-11-17 07:50:00	SPY	ETF	110.77	110.85	110.77	110.85	3300.0
2009-11-17 07:55:00	SPY	ETF	110.85	110.86	110.82	110.86	73800.0
2009-11-17 08:00:00	SPY	ETF	110.58	111.05	110.58	110.86	207996.0
2009-11-17 08:05:00	SPY	ETF	110.87	110.87	110.83	110.83	40599.0
2009-11-17 08:10:00	SPY	ETF	110.83	110.83	110.81	110.83	117300.0
2009-11-17 08:15:00	SPY	ETF	110.83	110.86	110.81	110.86	74132.0
2009-11-17 08:20:00	SPY	ETF	110.85	110.85	110.82	110.82	72620.0
2009-11-17 08:25:00	SPY	ETF	110.83	110.88	110.79	110.86	162792.0
2009-11-17 08:30:00	SPY	ETF	110.86	111.0	110.74	110.89	790290.0
2009-11-17 08:35:00	SPY	ETF	110.87	111.04	110.87	111.02	309675.0
2009-11-17 08:40:00	SPY	ETF	111.02	111.03	110.98	111.01	135487.0
2009-11-17 08:45:00	SPY	ETF	111.01	111.03	110.98	110.98	181220.0
2009-11-17 08:50:00	SPY	ETF	110.98	110.99	110.9	110.93	186755.0
2009-11-17 08:55:00	SPY	ETF	110.92	110.95	110.9	110.95	154571.0
2009-11-17 09:00:00	SPY	ETF	110.95	110.99	110.94	110.99	138381.0
2009-11-17 09:05:00	SPY	ETF	110.99	111.0	110.95	110.96	74410.0
2009-11-17 09:10:00	SPY	ETF	110.96	110.97	110.92	110.92	107152.0
2009-11-17 09:15:00	SPY	ETF	110.91	111.22	110.81	110.84	330067.0
2009-11-17 09:20:00	SPY	ETF	110.84	110.89	110.84	110.86	158375.0
2009-11-17 09:25:00	SPY	ETF	110.86	110.93	110.86	110.93	231626.0
2009-11-17 09:30:00	SPY	ETF	110.92	110.96	110.76	110.84	5396365.0
2009-11-17 09:35:00	SPY	ETF	110.84	111.03	110.74	110.86	3941010.0
2009-11-17 09:40:00	SPY	ETF	110.86	111.13	110.83	111.04	3775493.0
2009-11-17 09:45:00	SPY	ETF	111.04	111.2	111.04	111.1	3337978.0
2009-11-17 09:50:00	SPY	ETF	111.1	111.23	111.04	111.05	2845746.0
2009-11-17 09:55:00	SPY	ETF	111.05	111.12	110.98	110.991	2472065.0
2009-11-17 10:00:00	SPY	ETF	111.0	111.14	110.87	110.89	2890151.0

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

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