PREVIEW / etf_5min / 2018-10-15

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-10-15.parquet
  size:    1.4 MB
  rows:    62,091

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-10-15 04:00:00	SPY	ETF	274.7	274.7	274.53	274.64	14666.0
2018-10-15 04:05:00	SPY	ETF	274.67	274.82	274.67	274.8	26525.0
2018-10-15 04:10:00	SPY	ETF	274.77	274.77	274.46	274.52	21312.0
2018-10-15 04:15:00	SPY	ETF	274.48	274.57	274.3	274.3	6921.0
2018-10-15 04:20:00	SPY	ETF	274.28	274.33	273.96	273.99	21994.0
2018-10-15 04:25:00	SPY	ETF	273.98	274.12	273.98	274.12	1980.0
2018-10-15 04:30:00	SPY	ETF	274.09	274.09	274.09	274.09	300.0
2018-10-15 04:35:00	SPY	ETF	274.01	274.12	273.85	273.85	6200.0
2018-10-15 04:40:00	SPY	ETF	273.85	273.99	273.8	273.99	2650.0
2018-10-15 04:45:00	SPY	ETF	273.89	273.89	273.73	273.73	7832.0
2018-10-15 04:50:00	SPY	ETF	273.8	273.94	273.7	273.94	17945.0
2018-10-15 04:55:00	SPY	ETF	273.89	273.94	273.81	273.86	20460.0
2018-10-15 05:00:00	SPY	ETF	273.86	273.95	273.8	273.95	19503.0
2018-10-15 05:05:00	SPY	ETF	273.96	274.11	273.86	274.06	12160.0
2018-10-15 05:10:00	SPY	ETF	274.06	274.25	274.06	274.25	4430.0
2018-10-15 05:15:00	SPY	ETF	274.23	274.23	274.18	274.18	10680.0
2018-10-15 05:20:00	SPY	ETF	274.28	274.6	274.26	274.56	17150.0
2018-10-15 05:25:00	SPY	ETF	274.54	274.54	274.42	274.51	21035.0
2018-10-15 05:30:00	SPY	ETF	274.53	274.58	274.48	274.58	7301.0
2018-10-15 05:35:00	SPY	ETF	274.54	274.7	274.45	274.66	15300.0
2018-10-15 05:40:00	SPY	ETF	274.65	274.65	274.64	274.64	11600.0
2018-10-15 05:45:00	SPY	ETF	274.59	274.59	274.55	274.55	6400.0
2018-10-15 05:50:00	SPY	ETF	274.62	274.98	274.57	274.88	34550.0
2018-10-15 05:55:00	SPY	ETF	274.91	274.91	274.74	274.82	11452.0
2018-10-15 06:00:00	SPY	ETF	274.84	274.85	274.74	274.78	8220.0
2018-10-15 06:05:00	SPY	ETF	274.88	275.02	274.87	275.02	6505.0
2018-10-15 06:10:00	SPY	ETF	274.97	275.05	274.94	274.95	25706.0
2018-10-15 06:15:00	SPY	ETF	275.0	275.0	274.92	274.92	3800.0
2018-10-15 06:20:00	SPY	ETF	274.92	274.98	274.77	274.78	6100.0
2018-10-15 06:25:00	SPY	ETF	274.79	274.79	274.74	274.75	5700.0
2018-10-15 06:30:00	SPY	ETF	274.75	274.75	274.68	274.7	7755.0
2018-10-15 06:35:00	SPY	ETF	274.73	274.73	274.6	274.61	46275.0
2018-10-15 06:40:00	SPY	ETF	274.8	274.8	274.74	274.74	23900.0
2018-10-15 06:45:00	SPY	ETF	274.77	274.9	274.77	274.78	10750.0
2018-10-15 06:50:00	SPY	ETF	274.8	274.86	274.74	274.84	4550.0
2018-10-15 06:55:00	SPY	ETF	274.86	274.91	274.74	274.75	7964.0
2018-10-15 07:00:00	SPY	ETF	274.72	274.81	274.66	274.69	29856.0
2018-10-15 07:05:00	SPY	ETF	274.68	275.0	274.68	275.0	39197.0
2018-10-15 07:10:00	SPY	ETF	275.05	275.12	274.97	275.06	11844.0
2018-10-15 07:15:00	SPY	ETF	275.09	275.2	275.05	275.12	17715.0
2018-10-15 07:20:00	SPY	ETF	275.2	275.39	275.18	275.33	54701.0
2018-10-15 07:25:00	SPY	ETF	275.3	275.34	275.21	275.34	13000.0
2018-10-15 07:30:00	SPY	ETF	275.28	275.39	275.25	275.34	19864.0
2018-10-15 07:35:00	SPY	ETF	275.34	275.69	275.34	275.64	49665.0
2018-10-15 07:40:00	SPY	ETF	275.66	275.83	275.65	275.81	46369.0
2018-10-15 07:45:00	SPY	ETF	275.81	275.9	275.77	275.87	113163.0
2018-10-15 07:50:00	SPY	ETF	275.87	275.94	275.84	275.94	82190.0
2018-10-15 07:55:00	SPY	ETF	275.95	275.99	275.76	275.8	123031.0
2018-10-15 08:00:00	SPY	ETF	275.95	275.95	274.58	275.83	62962.0
2018-10-15 08:05:00	SPY	ETF	275.77	275.81	275.64	275.66	37673.0

> showing 50 of 62,091 rows — these rows as CSV

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