PREVIEW / etf_5min / 2020-03-12

all etf 5-min files

  file:    by_date/etf_5min/2020/2020-03-12.parquet
  size:    2.2 MB
  rows:    96,299

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
2020-03-12 04:00:00	SPY	ETF	263.95	264.22	263.03	263.98	47695.0
2020-03-12 04:05:00	SPY	ETF	264.02	265.0	263.58	263.58	24722.0
2020-03-12 04:10:00	SPY	ETF	263.5	264.01	263.36	263.74	28684.0
2020-03-12 04:15:00	SPY	ETF	263.9	264.88	263.48	264.37	16498.0
2020-03-12 04:20:00	SPY	ETF	264.26	264.26	263.8	263.84	8185.0
2020-03-12 04:25:00	SPY	ETF	263.71	263.71	262.75	262.75	14399.0
2020-03-12 04:30:00	SPY	ETF	262.74	263.18	262.52	262.78	7411.0
2020-03-12 04:35:00	SPY	ETF	262.5	262.5	261.75	261.94	27024.0
2020-03-12 04:40:00	SPY	ETF	262.05	262.28	261.52	261.8	20598.0
2020-03-12 04:45:00	SPY	ETF	261.55	261.55	261.1	261.1	18284.0
2020-03-12 04:50:00	SPY	ETF	261.29	262.04	261.02	261.78	21868.0
2020-03-12 04:55:00	SPY	ETF	261.93	262.25	261.5	261.52	13314.0
2020-03-12 05:00:00	SPY	ETF	261.43	261.59	261.12	261.12	8628.0
2020-03-12 05:05:00	SPY	ETF	261.11	261.46	260.9	260.93	40969.0
2020-03-12 05:10:00	SPY	ETF	260.9	261.07	260.8	260.8	12955.0
2020-03-12 05:15:00	SPY	ETF	260.8	261.02	260.8	260.95	11870.0
2020-03-12 05:20:00	SPY	ETF	261.02	261.36	261.02	261.23	7526.0
2020-03-12 05:25:00	SPY	ETF	261.21	261.31	260.77	260.8	29261.0
2020-03-12 05:30:00	SPY	ETF	260.85	261.3	260.75	260.98	17541.0
2020-03-12 05:35:00	SPY	ETF	260.92	260.92	260.8	260.82	11168.0
2020-03-12 05:40:00	SPY	ETF	260.8	261.5	260.73	261.27	26391.0
2020-03-12 05:45:00	SPY	ETF	261.23	263.56	261.22	263.56	58372.0
2020-03-12 05:50:00	SPY	ETF	263.56	263.68	262.69	262.89	19442.0
2020-03-12 05:55:00	SPY	ETF	262.93	263.09	262.38	262.38	5713.0
2020-03-12 06:00:00	SPY	ETF	262.3	262.37	261.88	261.88	30134.0
2020-03-12 06:05:00	SPY	ETF	262.03	262.11	261.53	261.95	10763.0
2020-03-12 06:10:00	SPY	ETF	262.02	262.33	261.42	261.57	4651.0
2020-03-12 06:15:00	SPY	ETF	261.65	261.65	261.2	261.29	22866.0
2020-03-12 06:20:00	SPY	ETF	261.32	261.37	260.73	260.73	25952.0
2020-03-12 06:25:00	SPY	ETF	260.8	261.67	260.8	261.65	12297.0
2020-03-12 06:30:00	SPY	ETF	261.25	261.61	261.21	261.37	9102.0
2020-03-12 06:35:00	SPY	ETF	261.48	261.9	261.04	261.77	19426.0
2020-03-12 06:40:00	SPY	ETF	261.77	262.31	261.77	261.99	9911.0
2020-03-12 06:45:00	SPY	ETF	261.92	262.5	261.84	262.07	7341.0
2020-03-12 06:50:00	SPY	ETF	261.91	262.5	261.91	262.46	34371.0
2020-03-12 06:55:00	SPY	ETF	262.36	262.96	262.25	262.96	43064.0
2020-03-12 07:00:00	SPY	ETF	262.81	262.96	262.3	262.4	95517.0
2020-03-12 07:05:00	SPY	ETF	262.29	262.3	261.57	261.83	75358.0
2020-03-12 07:10:00	SPY	ETF	261.7	262.06	261.65	261.9	46128.0
2020-03-12 07:15:00	SPY	ETF	261.8	262.24	261.72	261.88	77896.0
2020-03-12 07:20:00	SPY	ETF	261.96	262.05	261.41	261.56	144471.0
2020-03-12 07:25:00	SPY	ETF	261.56	261.67	261.15	261.54	72127.0
2020-03-12 07:30:00	SPY	ETF	261.56	261.63	261.31	261.63	61399.0
2020-03-12 07:35:00	SPY	ETF	261.58	262.0	261.5	261.65	80671.0
2020-03-12 07:40:00	SPY	ETF	261.74	262.0	261.36	261.41	132859.0
2020-03-12 07:45:00	SPY	ETF	261.34	261.7	261.22	261.3	119510.0
2020-03-12 07:50:00	SPY	ETF	261.32	261.32	260.94	261.12	168135.0
2020-03-12 07:55:00	SPY	ETF	261.1	261.13	260.78	260.9	62965.0
2020-03-12 08:00:00	SPY	ETF	265.0	267.41	259.77	259.8	379298.0
2020-03-12 08:05:00	SPY	ETF	259.81	261.0	259.51	260.03	156734.0

> showing 50 of 96,299 rows — these rows as CSV

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