PREVIEW / etf_5min / 2009-07-28

all etf 5-min files

  file:    by_date/etf_5min/2009/2009-07-28.parquet
  size:    724 KB
  rows:    30,337

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-28 04:05:00	SPY	ETF	98.45	98.45	98.45	98.45	600.0
2009-07-28 04:15:00	SPY	ETF	98.35	98.35	98.33	98.33	5200.0
2009-07-28 04:20:00	SPY	ETF	98.38	98.38	98.38	98.38	500.0
2009-07-28 04:30:00	SPY	ETF	98.33	98.34	98.33	98.34	8800.0
2009-07-28 04:35:00	SPY	ETF	98.31	98.31	98.3	98.3	2600.0
2009-07-28 04:45:00	SPY	ETF	98.29	98.3	98.24	98.24	7000.0
2009-07-28 04:50:00	SPY	ETF	98.3	98.3	98.3	98.3	100.0
2009-07-28 04:55:00	SPY	ETF	98.2	98.24	98.2	98.24	2900.0
2009-07-28 05:05:00	SPY	ETF	98.3	98.3	98.3	98.3	1000.0
2009-07-28 05:15:00	SPY	ETF	98.24	98.24	98.24	98.24	1000.0
2009-07-28 05:20:00	SPY	ETF	98.2	98.2	98.17	98.17	3600.0
2009-07-28 05:30:00	SPY	ETF	98.06	98.08	98.06	98.08	9600.0
2009-07-28 05:35:00	SPY	ETF	98.14	98.14	98.14	98.14	4000.0
2009-07-28 05:55:00	SPY	ETF	98.17	98.17	98.17	98.17	1500.0
2009-07-28 06:10:00	SPY	ETF	98.16	98.16	98.16	98.16	5300.0
2009-07-28 06:15:00	SPY	ETF	98.22	98.22	98.22	98.22	500.0
2009-07-28 06:25:00	SPY	ETF	98.21	98.21	98.21	98.21	100.0
2009-07-28 06:30:00	SPY	ETF	98.25	98.25	98.18	98.2	12500.0
2009-07-28 06:35:00	SPY	ETF	98.15	98.15	98.15	98.15	1500.0
2009-07-28 06:40:00	SPY	ETF	98.0	98.0	98.0	98.0	2000.0
2009-07-28 06:50:00	SPY	ETF	97.96	97.98	97.96	97.98	1500.0
2009-07-28 07:00:00	SPY	ETF	98.03	98.05	98.03	98.05	16300.0
2009-07-28 07:05:00	SPY	ETF	98.0	98.0	98.0	98.0	16500.0
2009-07-28 07:10:00	SPY	ETF	98.02	98.02	98.0	98.0	9000.0
2009-07-28 07:15:00	SPY	ETF	98.01	98.04	97.98	98.0	24700.0
2009-07-28 07:20:00	SPY	ETF	97.97	97.97	97.9	97.95	40715.0
2009-07-28 07:25:00	SPY	ETF	97.93	98.02	97.93	98.0	46700.0
2009-07-28 07:30:00	SPY	ETF	98.01	98.01	97.9	97.9	22762.0
2009-07-28 07:35:00	SPY	ETF	97.9	97.96	97.9	97.9	206132.0
2009-07-28 07:40:00	SPY	ETF	97.9	97.9	97.8	97.8	102007.0
2009-07-28 07:45:00	SPY	ETF	97.82	97.83	97.72	97.75	64700.0
2009-07-28 07:50:00	SPY	ETF	97.74	97.76	97.7	97.74	95802.0
2009-07-28 07:55:00	SPY	ETF	97.74	97.74	97.69	97.7	52090.0
2009-07-28 08:00:00	SPY	ETF	97.71	97.8	97.7	97.8	91925.0
2009-07-28 08:05:00	SPY	ETF	97.79	97.84	97.78	97.81	601256.0
2009-07-28 08:10:00	SPY	ETF	97.8	97.83	97.79	97.79	78978.0
2009-07-28 08:15:00	SPY	ETF	97.79	97.84	97.78	97.79	58376.0
2009-07-28 08:20:00	SPY	ETF	97.79	97.81	97.76	97.77	149465.0
2009-07-28 08:25:00	SPY	ETF	97.77	97.78	97.75	97.78	88543.0
2009-07-28 08:30:00	SPY	ETF	97.78	97.83	97.76	97.82	52128.0
2009-07-28 08:35:00	SPY	ETF	97.82	97.83	97.71	97.71	136203.0
2009-07-28 08:40:00	SPY	ETF	97.72	97.78	97.69	97.77	663796.0
2009-07-28 08:45:00	SPY	ETF	97.77	97.81	97.74	97.76	165887.0
2009-07-28 08:50:00	SPY	ETF	97.76	97.83	97.71	97.81	175383.0
2009-07-28 08:55:00	SPY	ETF	97.81	97.91	97.81	97.9	156215.0
2009-07-28 09:00:00	SPY	ETF	97.91	98.04	97.74	97.8	648251.0
2009-07-28 09:05:00	SPY	ETF	97.79	97.84	97.73	97.73	442471.0
2009-07-28 09:10:00	SPY	ETF	97.73	97.76	97.71	97.72	138093.0
2009-07-28 09:15:00	SPY	ETF	97.72	97.79	97.68	97.78	130940.0
2009-07-28 09:20:00	SPY	ETF	97.78	97.79	97.71	97.72	135462.0

> showing 50 of 30,337 rows — these rows as CSV

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