PREVIEW / etf_5min / 2009-04-23

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-04-23.parquet
  size:    680 KB
  rows:    29,730

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-23 04:15:00	SPY	ETF	84.94	85.0	84.94	85.0	1300.0
2009-04-23 04:20:00	SPY	ETF	84.89	85.0	84.89	85.0	5490.0
2009-04-23 04:25:00	SPY	ETF	85.02	85.02	85.02	85.02	167.0
2009-04-23 04:30:00	SPY	ETF	84.95	84.95	84.87	84.87	1000.0
2009-04-23 04:35:00	SPY	ETF	84.89	84.89	84.89	84.89	100.0
2009-04-23 05:15:00	SPY	ETF	84.87	84.87	84.85	84.85	1500.0
2009-04-23 05:20:00	SPY	ETF	84.94	84.97	84.93	84.97	600.0
2009-04-23 05:25:00	SPY	ETF	85.07	85.14	85.07	85.14	7600.0
2009-04-23 05:30:00	SPY	ETF	85.11	85.16	85.07	85.07	2500.0
2009-04-23 05:40:00	SPY	ETF	85.05	85.11	85.04	85.11	3300.0
2009-04-23 05:45:00	SPY	ETF	85.16	85.2	85.16	85.19	2400.0
2009-04-23 05:50:00	SPY	ETF	85.15	85.16	85.13	85.13	400.0
2009-04-23 05:55:00	SPY	ETF	85.06	85.06	85.02	85.02	500.0
2009-04-23 06:00:00	SPY	ETF	85.09	85.09	85.09	85.09	100.0
2009-04-23 06:25:00	SPY	ETF	85.05	85.05	85.05	85.05	100.0
2009-04-23 06:30:00	SPY	ETF	84.96	84.96	84.96	84.96	2000.0
2009-04-23 06:35:00	SPY	ETF	85.01	85.01	84.96	85.0	5200.0
2009-04-23 06:40:00	SPY	ETF	85.01	85.01	84.9	84.9	6100.0
2009-04-23 06:45:00	SPY	ETF	84.88	84.88	84.77	84.8	20100.0
2009-04-23 06:50:00	SPY	ETF	84.78	84.88	84.78	84.85	12000.0
2009-04-23 06:55:00	SPY	ETF	84.91	84.91	84.85	84.85	4300.0
2009-04-23 07:00:00	SPY	ETF	84.85	84.92	84.81	84.9	39706.0
2009-04-23 07:05:00	SPY	ETF	84.92	85.04	84.89	84.98	56849.0
2009-04-23 07:10:00	SPY	ETF	85.0	85.06	84.97	85.03	73200.0
2009-04-23 07:15:00	SPY	ETF	85.03	85.11	85.03	85.07	99887.0
2009-04-23 07:20:00	SPY	ETF	85.07	85.26	85.07	85.23	94421.0
2009-04-23 07:25:00	SPY	ETF	85.19	85.26	85.16	85.16	82512.0
2009-04-23 07:30:00	SPY	ETF	85.14	85.16	85.11	85.12	393127.0
2009-04-23 07:35:00	SPY	ETF	85.14	85.17	85.06	85.06	149667.0
2009-04-23 07:40:00	SPY	ETF	85.06	85.07	85.02	85.03	121193.0
2009-04-23 07:45:00	SPY	ETF	85.03	85.03	84.75	84.75	322354.0
2009-04-23 07:50:00	SPY	ETF	84.75	84.9	84.74	84.88	143875.0
2009-04-23 07:55:00	SPY	ETF	84.88	84.97	84.88	84.95	61971.0
2009-04-23 08:00:00	SPY	ETF	85.04	85.12	84.94	85.02	250656.0
2009-04-23 08:05:00	SPY	ETF	85.01	85.02	84.88	84.88	430046.0
2009-04-23 08:10:00	SPY	ETF	84.87	84.94	84.85	84.94	109165.0
2009-04-23 08:15:00	SPY	ETF	84.95	85.05	84.95	85.04	210039.0
2009-04-23 08:20:00	SPY	ETF	85.04	85.16	85.03	85.15	464943.0
2009-04-23 08:25:00	SPY	ETF	85.16	85.18	85.12	85.15	418949.0
2009-04-23 08:30:00	SPY	ETF	85.14	85.16	84.74	84.87	1293644.0
2009-04-23 08:35:00	SPY	ETF	84.87	84.94	84.71	84.9	653736.0
2009-04-23 08:40:00	SPY	ETF	84.9	85.05	84.87	84.98	116266.0
2009-04-23 08:45:00	SPY	ETF	84.97	85.05	84.97	85.03	192363.0
2009-04-23 08:50:00	SPY	ETF	85.03	85.04	84.87	84.94	195166.0
2009-04-23 08:55:00	SPY	ETF	84.93	84.98	84.86	84.94	130904.0
2009-04-23 09:00:00	SPY	ETF	84.95	85.0	84.65	84.67	459047.0
2009-04-23 09:05:00	SPY	ETF	84.66	84.82	84.65	84.74	370917.0
2009-04-23 09:10:00	SPY	ETF	84.74	84.82	84.71	84.79	425005.0
2009-04-23 09:15:00	SPY	ETF	84.79	84.79	84.57	84.62	306861.0
2009-04-23 09:20:00	SPY	ETF	84.62	84.77	84.62	84.76	293006.0

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

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