PREVIEW / etf_5min / 2009-07-30

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-30.parquet
  size:    744 KB
  rows:    31,073

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-07-30 04:05:00	SPY	ETF	98.1	98.1	98.1	98.1	300.0
2009-07-30 04:10:00	SPY	ETF	98.21	98.21	98.21	98.21	2500.0
2009-07-30 04:15:00	SPY	ETF	98.12	98.2	98.12	98.2	768.0
2009-07-30 04:20:00	SPY	ETF	98.23	98.23	98.23	98.23	100.0
2009-07-30 04:45:00	SPY	ETF	98.33	98.41	98.33	98.41	2800.0
2009-07-30 04:50:00	SPY	ETF	98.45	98.47	98.45	98.47	1150.0
2009-07-30 04:55:00	SPY	ETF	98.49	98.53	98.49	98.53	7800.0
2009-07-30 05:00:00	SPY	ETF	98.53	98.53	98.53	98.53	100.0
2009-07-30 05:05:00	SPY	ETF	98.58	98.59	98.58	98.59	8000.0
2009-07-30 05:10:00	SPY	ETF	98.6	98.6	98.6	98.6	711.0
2009-07-30 05:15:00	SPY	ETF	98.57	98.57	98.57	98.57	1000.0
2009-07-30 05:20:00	SPY	ETF	98.6	98.65	98.6	98.64	1900.0
2009-07-30 05:25:00	SPY	ETF	98.67	98.67	98.67	98.67	100.0
2009-07-30 05:30:00	SPY	ETF	98.7	98.7	98.7	98.7	300.0
2009-07-30 05:35:00	SPY	ETF	98.67	98.67	98.67	98.67	2500.0
2009-07-30 05:40:00	SPY	ETF	98.65	98.66	98.65	98.66	2500.0
2009-07-30 06:00:00	SPY	ETF	98.65	98.69	98.65	98.69	600.0
2009-07-30 06:05:00	SPY	ETF	98.74	98.74	98.74	98.74	500.0
2009-07-30 06:10:00	SPY	ETF	98.69	98.69	98.68	98.68	1100.0
2009-07-30 06:15:00	SPY	ETF	98.72	98.72	98.7	98.7	10200.0
2009-07-30 06:20:00	SPY	ETF	98.74	98.85	98.74	98.85	3300.0
2009-07-30 06:25:00	SPY	ETF	98.85	98.85	98.82	98.82	1100.0
2009-07-30 06:30:00	SPY	ETF	98.8	98.8	98.75	98.75	7600.0
2009-07-30 06:45:00	SPY	ETF	98.7	98.72	98.7	98.72	1300.0
2009-07-30 06:50:00	SPY	ETF	98.7	98.72	98.69	98.69	724.0
2009-07-30 06:55:00	SPY	ETF	98.69	98.69	98.67	98.67	33000.0
2009-07-30 07:00:00	SPY	ETF	98.68	98.7	98.68	98.68	52334.0
2009-07-30 07:05:00	SPY	ETF	98.68	98.74	98.68	98.72	37650.0
2009-07-30 07:10:00	SPY	ETF	98.7	98.74	98.67	98.67	19100.0
2009-07-30 07:15:00	SPY	ETF	98.71	98.73	98.7	98.72	37300.0
2009-07-30 07:20:00	SPY	ETF	98.7	98.73	98.7	98.71	6715.0
2009-07-30 07:25:00	SPY	ETF	98.64	98.66	98.6	98.61	35000.0
2009-07-30 07:30:00	SPY	ETF	98.6	98.61	98.55	98.61	68317.0
2009-07-30 07:35:00	SPY	ETF	98.62	98.66	98.6	98.61	162162.0
2009-07-30 07:40:00	SPY	ETF	98.61	98.66	98.61	98.66	108108.0
2009-07-30 07:45:00	SPY	ETF	98.66	98.66	98.59	98.61	48403.0
2009-07-30 07:50:00	SPY	ETF	98.61	98.64	98.58	98.64	213969.0
2009-07-30 07:55:00	SPY	ETF	98.64	98.65	98.62	98.65	41036.0
2009-07-30 08:00:00	SPY	ETF	98.65	98.81	98.49	98.57	769672.0
2009-07-30 08:05:00	SPY	ETF	98.59	98.63	98.58	98.6	141708.0
2009-07-30 08:10:00	SPY	ETF	98.6	98.7	98.53	98.61	520064.0
2009-07-30 08:15:00	SPY	ETF	98.61	98.75	98.58	98.62	125601.0
2009-07-30 08:20:00	SPY	ETF	98.61	98.68	98.57	98.64	408145.0
2009-07-30 08:25:00	SPY	ETF	98.64	98.7	98.58	98.61	535615.0
2009-07-30 08:30:00	SPY	ETF	98.6	99.07	98.32	98.85	2373760.0
2009-07-30 08:35:00	SPY	ETF	98.84	98.94	98.76	98.94	336031.0
2009-07-30 08:40:00	SPY	ETF	98.93	99.08	98.88	99.06	717286.0
2009-07-30 08:45:00	SPY	ETF	99.05	99.1	98.99	99.05	478044.0
2009-07-30 08:50:00	SPY	ETF	99.05	99.06	98.99	99.01	690800.0
2009-07-30 08:55:00	SPY	ETF	99.0	99.03	98.19	98.96	766081.0

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

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