PREVIEW / etf_5min / 2009-06-01

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-06-01.parquet
  size:    746 KB
  rows:    32,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-06-01 04:15:00	SPY	ETF	93.72	93.72	93.64	93.64	3881.0
2009-06-01 04:25:00	SPY	ETF	93.7	93.7	93.7	93.7	400.0
2009-06-01 04:30:00	SPY	ETF	93.76	93.76	93.76	93.76	3500.0
2009-06-01 04:35:00	SPY	ETF	93.77	93.8	93.77	93.79	376.0
2009-06-01 04:40:00	SPY	ETF	93.8	93.8	93.74	93.74	700.0
2009-06-01 04:45:00	SPY	ETF	93.78	93.78	93.78	93.78	5000.0
2009-06-01 04:55:00	SPY	ETF	93.76	93.76	93.76	93.76	5000.0
2009-06-01 05:00:00	SPY	ETF	93.83	93.83	93.83	93.83	400.0
2009-06-01 05:05:00	SPY	ETF	93.85	93.85	93.85	93.85	600.0
2009-06-01 05:15:00	SPY	ETF	93.68	93.75	93.68	93.75	2000.0
2009-06-01 05:20:00	SPY	ETF	93.72	93.74	93.69	93.7	28100.0
2009-06-01 05:40:00	SPY	ETF	93.79	93.8	93.79	93.8	600.0
2009-06-01 05:55:00	SPY	ETF	93.8	93.83	93.77	93.83	20500.0
2009-06-01 06:00:00	SPY	ETF	93.83	94.1	93.83	94.05	22500.0
2009-06-01 06:05:00	SPY	ETF	94.02	94.02	93.95	93.95	2700.0
2009-06-01 06:10:00	SPY	ETF	93.9	93.9	93.9	93.9	2500.0
2009-06-01 06:15:00	SPY	ETF	93.85	93.85	93.85	93.85	5000.0
2009-06-01 06:20:00	SPY	ETF	93.83	93.83	93.83	93.83	3500.0
2009-06-01 06:25:00	SPY	ETF	93.81	93.85	93.81	93.85	1600.0
2009-06-01 06:30:00	SPY	ETF	93.9	93.93	93.88	93.88	2300.0
2009-06-01 06:35:00	SPY	ETF	93.88	93.88	93.78	93.78	16500.0
2009-06-01 06:40:00	SPY	ETF	93.78	93.78	93.74	93.74	7200.0
2009-06-01 06:45:00	SPY	ETF	93.74	93.74	93.69	93.69	14500.0
2009-06-01 06:50:00	SPY	ETF	93.71	93.71	93.65	93.65	4900.0
2009-06-01 06:55:00	SPY	ETF	93.65	93.69	93.64	93.66	12800.0
2009-06-01 07:00:00	SPY	ETF	93.64	93.64	93.58	93.64	56945.0
2009-06-01 07:05:00	SPY	ETF	93.63	93.71	93.63	93.71	27368.0
2009-06-01 07:10:00	SPY	ETF	93.71	93.71	93.65	93.65	30811.0
2009-06-01 07:15:00	SPY	ETF	93.64	93.64	93.44	93.5	220577.0
2009-06-01 07:20:00	SPY	ETF	93.49	93.59	93.49	93.55	85105.0
2009-06-01 07:25:00	SPY	ETF	93.55	93.6	93.55	93.6	27530.0
2009-06-01 07:30:00	SPY	ETF	93.58	93.63	93.57	93.57	65040.0
2009-06-01 07:35:00	SPY	ETF	93.57	93.61	93.56	93.56	89359.0
2009-06-01 07:40:00	SPY	ETF	93.58	93.59	93.41	93.45	107688.0
2009-06-01 07:45:00	SPY	ETF	93.45	93.45	93.33	93.33	118394.0
2009-06-01 07:50:00	SPY	ETF	93.34	93.44	93.33	93.44	104233.0
2009-06-01 07:55:00	SPY	ETF	93.45	93.48	93.44	93.44	117114.0
2009-06-01 08:00:00	SPY	ETF	93.44	93.7	93.44	93.64	849660.0
2009-06-01 08:05:00	SPY	ETF	93.65	93.72	93.65	93.66	137951.0
2009-06-01 08:10:00	SPY	ETF	93.66	93.71	93.62	93.7	264337.0
2009-06-01 08:15:00	SPY	ETF	93.7	93.85	93.69	93.75	536051.0
2009-06-01 08:20:00	SPY	ETF	93.75	93.78	93.53	93.55	374666.0
2009-06-01 08:25:00	SPY	ETF	93.55	93.61	93.52	93.56	229172.0
2009-06-01 08:30:00	SPY	ETF	93.57	93.79	92.44	93.79	755201.0
2009-06-01 08:35:00	SPY	ETF	93.78	93.87	93.69	93.84	426287.0
2009-06-01 08:40:00	SPY	ETF	93.83	93.85	93.68	93.69	254742.0
2009-06-01 08:45:00	SPY	ETF	93.7	93.7	93.6	93.64	310210.0
2009-06-01 08:50:00	SPY	ETF	93.64	93.68	93.62	93.67	136377.0
2009-06-01 08:55:00	SPY	ETF	93.66	93.69	92.75	93.67	74390.0
2009-06-01 09:00:00	SPY	ETF	93.67	93.75	93.67	93.74	176927.0

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

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