PREVIEW / etf_5min / 2009-04-17

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-04-17.parquet
  size:    673 KB
  rows:    29,893

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-04-17 04:20:00	SPY	ETF	86.1	86.18	86.1	86.18	1100.0
2009-04-17 05:00:00	SPY	ETF	86.05	86.05	86.05	86.05	100.0
2009-04-17 05:05:00	SPY	ETF	86.0	86.0	85.98	85.98	300.0
2009-04-17 05:15:00	SPY	ETF	86.0	86.02	86.0	86.02	300.0
2009-04-17 05:20:00	SPY	ETF	86.06	86.06	86.06	86.06	300.0
2009-04-17 05:25:00	SPY	ETF	86.07	86.07	86.07	86.07	600.0
2009-04-17 05:30:00	SPY	ETF	86.09	86.09	86.09	86.09	200.0
2009-04-17 05:35:00	SPY	ETF	86.09	86.09	86.09	86.09	201.0
2009-04-17 05:40:00	SPY	ETF	86.08	86.08	86.08	86.08	1000.0
2009-04-17 05:45:00	SPY	ETF	86.19	86.23	86.18	86.23	11300.0
2009-04-17 05:50:00	SPY	ETF	86.25	86.43	86.24	86.43	3000.0
2009-04-17 05:55:00	SPY	ETF	86.41	86.53	86.41	86.42	2800.0
2009-04-17 06:00:00	SPY	ETF	86.29	86.42	86.29	86.42	25750.0
2009-04-17 06:10:00	SPY	ETF	86.41	86.47	86.41	86.45	15050.0
2009-04-17 06:15:00	SPY	ETF	86.43	86.43	86.43	86.43	147.0
2009-04-17 06:20:00	SPY	ETF	86.43	86.54	86.42	86.54	78822.0
2009-04-17 06:25:00	SPY	ETF	86.54	86.78	86.52	86.66	18600.0
2009-04-17 06:30:00	SPY	ETF	86.7	86.84	86.5	86.6	28950.0
2009-04-17 06:35:00	SPY	ETF	86.5	86.67	86.49	86.65	9400.0
2009-04-17 06:40:00	SPY	ETF	86.7	86.77	86.59	86.64	36000.0
2009-04-17 06:45:00	SPY	ETF	86.62	86.62	86.62	86.62	100.0
2009-04-17 06:50:00	SPY	ETF	86.57	86.7	86.57	86.7	7200.0
2009-04-17 06:55:00	SPY	ETF	86.74	86.76	86.66	86.75	42000.0
2009-04-17 07:00:00	SPY	ETF	86.8	87.05	86.8	86.96	26694.0
2009-04-17 07:05:00	SPY	ETF	87.02	87.02	86.87	86.9	54450.0
2009-04-17 07:10:00	SPY	ETF	86.88	86.88	86.76	86.76	11160.0
2009-04-17 07:15:00	SPY	ETF	86.72	86.72	86.58	86.67	28628.0
2009-04-17 07:20:00	SPY	ETF	86.67	86.7	86.62	86.62	69452.0
2009-04-17 07:25:00	SPY	ETF	86.62	86.65	86.51	86.64	96100.0
2009-04-17 07:30:00	SPY	ETF	86.67	86.68	86.57	86.57	48800.0
2009-04-17 07:35:00	SPY	ETF	86.56	86.61	86.56	86.61	65700.0
2009-04-17 07:40:00	SPY	ETF	86.62	86.79	86.62	86.77	85300.0
2009-04-17 07:45:00	SPY	ETF	86.76	86.78	86.7	86.7	37200.0
2009-04-17 07:50:00	SPY	ETF	86.68	86.78	86.68	86.78	60501.0
2009-04-17 07:55:00	SPY	ETF	86.73	86.9	86.73	86.88	101907.0
2009-04-17 08:00:00	SPY	ETF	86.87	86.91	86.64	86.91	345392.0
2009-04-17 08:05:00	SPY	ETF	86.9	86.9	86.8	86.83	213170.0
2009-04-17 08:10:00	SPY	ETF	86.83	86.91	86.82	86.91	110906.0
2009-04-17 08:15:00	SPY	ETF	86.91	86.94	86.8	86.8	323572.0
2009-04-17 08:20:00	SPY	ETF	86.8	86.91	86.8	86.9	225627.0
2009-04-17 08:25:00	SPY	ETF	86.91	86.96	85.9	86.94	135795.0
2009-04-17 08:30:00	SPY	ETF	86.93	86.93	86.79	86.79	110970.0
2009-04-17 08:35:00	SPY	ETF	86.79	86.79	86.73	86.78	134518.0
2009-04-17 08:40:00	SPY	ETF	86.78	86.78	86.7	86.7	100937.0
2009-04-17 08:45:00	SPY	ETF	86.7	86.7	86.6	86.63	516698.0
2009-04-17 08:50:00	SPY	ETF	86.62	86.68	86.59	86.59	244060.0
2009-04-17 08:55:00	SPY	ETF	86.59	86.65	86.15	86.39	947918.0
2009-04-17 09:00:00	SPY	ETF	86.4	86.69	86.37	86.65	800824.0
2009-04-17 09:05:00	SPY	ETF	86.65	86.65	86.55	86.56	336853.0
2009-04-17 09:10:00	SPY	ETF	86.56	86.61	86.53	86.58	351118.0

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

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