PREVIEW / etf_5min / 2018-06-27

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-06-27.parquet
  size:    1.4 MB
  rows:    61,500

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
2018-06-27 04:00:00	SPY	ETF	270.0	270.19	270.0	270.1	19061.0
2018-06-27 04:05:00	SPY	ETF	270.1	270.31	270.02	270.24	12985.0
2018-06-27 04:10:00	SPY	ETF	270.11	270.26	270.11	270.26	7850.0
2018-06-27 04:15:00	SPY	ETF	270.3	270.4	270.29	270.37	4800.0
2018-06-27 04:20:00	SPY	ETF	270.32	270.32	270.28	270.28	3400.0
2018-06-27 04:25:00	SPY	ETF	270.28	270.28	270.01	270.03	11100.0
2018-06-27 04:30:00	SPY	ETF	269.97	270.04	269.86	269.86	5750.0
2018-06-27 04:35:00	SPY	ETF	269.87	270.03	269.87	270.03	6650.0
2018-06-27 04:40:00	SPY	ETF	270.03	270.08	269.86	270.08	5250.0
2018-06-27 04:45:00	SPY	ETF	269.96	269.96	269.8	269.81	6500.0
2018-06-27 04:50:00	SPY	ETF	269.77	269.79	269.68	269.68	3380.0
2018-06-27 04:55:00	SPY	ETF	269.84	269.84	269.75	269.75	2050.0
2018-06-27 05:00:00	SPY	ETF	269.76	269.93	269.76	269.93	1600.0
2018-06-27 05:05:00	SPY	ETF	269.88	270.11	269.88	270.11	6250.0
2018-06-27 05:10:00	SPY	ETF	270.12	270.26	270.12	270.26	1165.0
2018-06-27 05:15:00	SPY	ETF	270.29	270.46	270.29	270.33	11950.0
2018-06-27 05:25:00	SPY	ETF	270.48	270.55	270.47	270.55	1625.0
2018-06-27 05:30:00	SPY	ETF	270.56	270.78	270.56	270.7	5885.0
2018-06-27 05:35:00	SPY	ETF	270.74	270.75	270.65	270.66	4418.0
2018-06-27 05:40:00	SPY	ETF	270.68	270.68	270.63	270.68	5750.0
2018-06-27 05:45:00	SPY	ETF	270.68	270.68	270.6	270.6	850.0
2018-06-27 05:50:00	SPY	ETF	270.6	270.71	270.6	270.7	2250.0
2018-06-27 05:55:00	SPY	ETF	270.75	271.15	270.75	271.05	9705.0
2018-06-27 06:00:00	SPY	ETF	271.14	271.17	271.03	271.08	8750.0
2018-06-27 06:05:00	SPY	ETF	271.11	271.21	271.01	271.21	6830.0
2018-06-27 06:10:00	SPY	ETF	271.17	271.17	271.02	271.02	7300.0
2018-06-27 06:15:00	SPY	ETF	271.07	271.07	270.95	270.99	6000.0
2018-06-27 06:20:00	SPY	ETF	270.99	271.01	270.99	271.01	200.0
2018-06-27 06:25:00	SPY	ETF	271.0	271.0	270.95	271.0	920.0
2018-06-27 06:30:00	SPY	ETF	270.95	270.95	270.92	270.92	1200.0
2018-06-27 06:35:00	SPY	ETF	270.8	270.89	270.78	270.89	1050.0
2018-06-27 06:40:00	SPY	ETF	270.99	271.03	270.95	270.97	4800.0
2018-06-27 06:45:00	SPY	ETF	271.0	271.0	270.8	270.8	3650.0
2018-06-27 06:50:00	SPY	ETF	270.79	270.92	270.78	270.92	2200.0
2018-06-27 06:55:00	SPY	ETF	270.93	270.93	270.84	270.84	5450.0
2018-06-27 07:00:00	SPY	ETF	270.85	270.97	270.85	270.94	44675.0
2018-06-27 07:05:00	SPY	ETF	271.0	271.0	270.94	270.94	26506.0
2018-06-27 07:10:00	SPY	ETF	270.88	270.92	270.84	270.84	41254.0
2018-06-27 07:15:00	SPY	ETF	270.84	270.88	270.77	270.77	33863.0
2018-06-27 07:20:00	SPY	ETF	270.71	270.71	270.61	270.62	16564.0
2018-06-27 07:25:00	SPY	ETF	270.62	270.7	270.55	270.57	14848.0
2018-06-27 07:30:00	SPY	ETF	270.58	270.62	270.52	270.52	9150.0
2018-06-27 07:35:00	SPY	ETF	270.6	270.64	270.6	270.64	3565.0
2018-06-27 07:40:00	SPY	ETF	270.67	270.68	270.31	270.31	66559.0
2018-06-27 07:45:00	SPY	ETF	270.33	271.92	270.33	271.82	605728.0
2018-06-27 07:50:00	SPY	ETF	271.87	272.15	271.76	271.8	173960.0
2018-06-27 07:55:00	SPY	ETF	271.76	272.0	271.73	271.85	60681.0
2018-06-27 08:00:00	SPY	ETF	270.5601	272.09	270.06	271.828	216486.0
2018-06-27 08:05:00	SPY	ETF	271.63	271.9	271.46	271.9	169218.0
2018-06-27 08:10:00	SPY	ETF	271.9	272.34	271.87	272.23	125558.0

> showing 50 of 61,500 rows — these rows as CSV

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