PREVIEW / etf_5min / 2009-03-18

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-03-18.parquet
  size:    708 KB
  rows:    29,378

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-03-18 04:15:00	SPY	ETF	78.26	78.26	78.26	78.26	100.0
2009-03-18 04:25:00	SPY	ETF	78.29	78.29	78.29	78.29	100.0
2009-03-18 04:50:00	SPY	ETF	78.07	78.07	78.07	78.07	700.0
2009-03-18 05:00:00	SPY	ETF	77.99	78.06	77.99	78.04	500.0
2009-03-18 05:25:00	SPY	ETF	77.91	77.91	77.9	77.9	300.0
2009-03-18 05:30:00	SPY	ETF	77.85	77.9	77.74	77.74	3700.0
2009-03-18 05:35:00	SPY	ETF	77.88	77.88	77.88	77.88	5000.0
2009-03-18 05:50:00	SPY	ETF	78.03	78.03	78.03	78.03	100.0
2009-03-18 05:55:00	SPY	ETF	77.88	77.88	77.8	77.8	200.0
2009-03-18 06:00:00	SPY	ETF	77.92	77.92	77.92	77.92	1000.0
2009-03-18 06:15:00	SPY	ETF	78.04	78.04	78.04	78.04	5000.0
2009-03-18 06:20:00	SPY	ETF	78.0	78.02	78.0	78.0	5100.0
2009-03-18 06:25:00	SPY	ETF	77.98	77.98	77.98	77.98	100.0
2009-03-18 06:35:00	SPY	ETF	77.98	78.0	77.98	78.0	15000.0
2009-03-18 06:40:00	SPY	ETF	77.99	77.99	77.99	77.99	5000.0
2009-03-18 06:45:00	SPY	ETF	78.0	78.01	77.98	78.0	16100.0
2009-03-18 06:50:00	SPY	ETF	77.95	77.95	77.95	77.95	2500.0
2009-03-18 06:55:00	SPY	ETF	77.91	77.91	77.9	77.9	2600.0
2009-03-18 07:00:00	SPY	ETF	77.98	78.0	77.93	78.0	53100.0
2009-03-18 07:05:00	SPY	ETF	78.0	78.05	77.96	78.05	7250.0
2009-03-18 07:10:00	SPY	ETF	78.08	78.16	78.08	78.12	5259.0
2009-03-18 07:15:00	SPY	ETF	78.14	78.26	78.14	78.2	27650.0
2009-03-18 07:20:00	SPY	ETF	78.2	78.23	78.14	78.14	6800.0
2009-03-18 07:25:00	SPY	ETF	78.15	78.15	78.15	78.15	1614.0
2009-03-18 07:30:00	SPY	ETF	78.15	78.17	78.08	78.1	18166.0
2009-03-18 07:35:00	SPY	ETF	78.08	78.08	78.01	78.04	81232.0
2009-03-18 07:40:00	SPY	ETF	78.03	78.12	78.02	78.04	65380.0
2009-03-18 07:45:00	SPY	ETF	78.07	78.1	77.96	77.97	63706.0
2009-03-18 07:50:00	SPY	ETF	78.01	78.02	77.96	77.97	35100.0
2009-03-18 07:55:00	SPY	ETF	78.0	78.0	77.88	77.9	117995.0
2009-03-18 08:00:00	SPY	ETF	77.91	78.12	77.83	77.9	210005.0
2009-03-18 08:05:00	SPY	ETF	77.9	77.91	77.77	77.87	204188.0
2009-03-18 08:10:00	SPY	ETF	77.87	77.95	77.8	77.95	91255.0
2009-03-18 08:15:00	SPY	ETF	77.93	78.06	77.89	77.98	85296.0
2009-03-18 08:20:00	SPY	ETF	78.0	78.01	77.8	77.86	552367.0
2009-03-18 08:25:00	SPY	ETF	77.87	77.97	77.85	77.93	48346.0
2009-03-18 08:30:00	SPY	ETF	77.93	78.02	77.78	77.87	398400.0
2009-03-18 08:35:00	SPY	ETF	77.86	77.92	77.81	77.83	207161.0
2009-03-18 08:40:00	SPY	ETF	77.82	77.85	77.73	77.76	84200.0
2009-03-18 08:45:00	SPY	ETF	77.82	77.93	77.78	77.88	70217.0
2009-03-18 08:50:00	SPY	ETF	77.86	77.93	77.79	77.81	165529.0
2009-03-18 08:55:00	SPY	ETF	77.86	77.89	77.82	77.85	136733.0
2009-03-18 09:00:00	SPY	ETF	77.86	77.86	77.65	77.71	179933.0
2009-03-18 09:05:00	SPY	ETF	77.7	78.0	77.56	77.6	1374731.0
2009-03-18 09:10:00	SPY	ETF	77.61	77.71	77.58	77.64	51824.0
2009-03-18 09:15:00	SPY	ETF	77.64	77.75	77.63	77.64	252497.0
2009-03-18 09:20:00	SPY	ETF	77.65	77.74	77.65	77.68	136071.0
2009-03-18 09:25:00	SPY	ETF	77.68	77.85	77.68	77.8	424680.0
2009-03-18 09:30:00	SPY	ETF	77.81	77.82	77.57	77.68	5042805.0
2009-03-18 09:35:00	SPY	ETF	77.69	77.81	77.52	77.76	4867309.0

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

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