PREVIEW / etf_5min / 2009-08-26

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-08-26.parquet
  size:    672 KB
  rows:    29,112

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-26 04:15:00	SPY	ETF	103.27	103.27	103.27	103.27	1100.0
2009-08-26 04:25:00	SPY	ETF	103.15	103.15	103.15	103.15	1000.0
2009-08-26 04:30:00	SPY	ETF	103.19	103.19	103.19	103.19	500.0
2009-08-26 05:10:00	SPY	ETF	103.16	103.16	103.16	103.16	100.0
2009-08-26 05:25:00	SPY	ETF	103.06	103.06	103.01	103.01	2000.0
2009-08-26 05:50:00	SPY	ETF	103.11	103.11	103.11	103.11	300.0
2009-08-26 06:10:00	SPY	ETF	103.19	103.19	103.19	103.19	100.0
2009-08-26 06:15:00	SPY	ETF	103.1	103.1	103.05	103.05	300.0
2009-08-26 06:20:00	SPY	ETF	103.0	103.0	103.0	103.0	300.0
2009-08-26 06:25:00	SPY	ETF	102.94	102.96	102.88	102.96	1300.0
2009-08-26 06:30:00	SPY	ETF	102.91	102.92	102.91	102.91	500.0
2009-08-26 06:40:00	SPY	ETF	102.88	102.88	102.85	102.85	900.0
2009-08-26 06:45:00	SPY	ETF	102.88	102.88	102.88	102.88	200.0
2009-08-26 06:50:00	SPY	ETF	102.88	102.88	102.88	102.88	100.0
2009-08-26 06:55:00	SPY	ETF	102.9	102.9	102.9	102.9	601.0
2009-08-26 07:00:00	SPY	ETF	102.97	102.97	102.88	102.96	18836.0
2009-08-26 07:05:00	SPY	ETF	102.96	102.96	102.94	102.96	21400.0
2009-08-26 07:10:00	SPY	ETF	102.93	102.94	102.91	102.92	18300.0
2009-08-26 07:15:00	SPY	ETF	102.94	102.94	102.85	102.85	6800.0
2009-08-26 07:20:00	SPY	ETF	102.84	102.84	102.75	102.75	11900.0
2009-08-26 07:25:00	SPY	ETF	102.75	102.8	102.7	102.71	92250.0
2009-08-26 07:30:00	SPY	ETF	102.71	102.76	102.71	102.76	4324.0
2009-08-26 07:35:00	SPY	ETF	102.75	102.75	102.73	102.73	2825.0
2009-08-26 07:40:00	SPY	ETF	102.76	102.77	102.74	102.74	10824.0
2009-08-26 07:45:00	SPY	ETF	102.76	102.82	102.76	102.79	29800.0
2009-08-26 07:50:00	SPY	ETF	102.78	102.86	102.76	102.84	45599.0
2009-08-26 07:55:00	SPY	ETF	102.85	102.92	102.84	102.92	31800.0
2009-08-26 08:00:00	SPY	ETF	102.92	103.45	102.73	102.87	387163.0
2009-08-26 08:05:00	SPY	ETF	102.85	102.97	102.84	102.9	266471.0
2009-08-26 08:10:00	SPY	ETF	102.9	102.97	102.9	102.96	70828.0
2009-08-26 08:15:00	SPY	ETF	102.97	102.99	102.95	102.97	61180.0
2009-08-26 08:20:00	SPY	ETF	102.98	103.02	102.97	103.02	61226.0
2009-08-26 08:25:00	SPY	ETF	103.02	103.21	102.94	103.01	967755.0
2009-08-26 08:30:00	SPY	ETF	103.0	103.49	102.83	102.89	2093772.0
2009-08-26 08:35:00	SPY	ETF	102.88	102.9	102.77	102.87	1101865.0
2009-08-26 08:40:00	SPY	ETF	102.86	103.0	102.82	102.97	296608.0
2009-08-26 08:45:00	SPY	ETF	102.97	103.14	102.94	102.99	315045.0
2009-08-26 08:50:00	SPY	ETF	102.99	103.08	102.99	103.03	187149.0
2009-08-26 08:55:00	SPY	ETF	103.03	103.04	102.89	102.96	362343.0
2009-08-26 09:00:00	SPY	ETF	102.96	102.97	102.88	102.89	284650.0
2009-08-26 09:05:00	SPY	ETF	102.88	102.95	102.87	102.94	237158.0
2009-08-26 09:10:00	SPY	ETF	102.93	102.99	102.92	102.95	136757.0
2009-08-26 09:15:00	SPY	ETF	102.94	102.97	102.92	102.95	113507.0
2009-08-26 09:20:00	SPY	ETF	102.95	102.96	102.9	102.92	143394.0
2009-08-26 09:25:00	SPY	ETF	102.92	102.93	102.82	102.85	280291.0
2009-08-26 09:30:00	SPY	ETF	102.84	102.98	102.71	102.88	5196375.0
2009-08-26 09:35:00	SPY	ETF	102.88	102.8899	102.62	102.81	3302866.0
2009-08-26 09:40:00	SPY	ETF	102.8	102.92	102.65	102.75	3035722.0
2009-08-26 09:45:00	SPY	ETF	102.75	102.8	102.53	102.57	2966958.0
2009-08-26 09:50:00	SPY	ETF	102.5799	102.71	102.49	102.7	3263181.0

> showing 50 of 29,112 rows — these rows as CSV

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