PREVIEW / etf_5min / 2018-01-30

all etf 5-min files

  file:    by_date/etf_5min/2018/2018-01-30.parquet
  size:    1.6 MB
  rows:    66,702

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-01-30 04:00:00	SPY	ETF	283.68	283.68	283.31	283.41	3229.0
2018-01-30 04:15:00	SPY	ETF	283.78	283.78	283.76	283.76	1100.0
2018-01-30 04:25:00	SPY	ETF	283.73	283.73	283.73	283.73	400.0
2018-01-30 04:30:00	SPY	ETF	283.75	283.75	283.58	283.58	4004.0
2018-01-30 04:35:00	SPY	ETF	283.73	283.73	283.73	283.73	350.0
2018-01-30 04:40:00	SPY	ETF	283.75	283.75	283.71	283.71	1750.0
2018-01-30 04:45:00	SPY	ETF	283.71	283.74	283.71	283.71	3006.0
2018-01-30 04:50:00	SPY	ETF	283.79	283.84	283.79	283.84	1335.0
2018-01-30 04:55:00	SPY	ETF	283.8	283.8	283.76	283.79	900.0
2018-01-30 05:00:00	SPY	ETF	283.89	283.89	283.85	283.89	2600.0
2018-01-30 05:05:00	SPY	ETF	283.85	283.86	283.84	283.84	1400.0
2018-01-30 05:10:00	SPY	ETF	283.72	283.72	283.6	283.64	800.0
2018-01-30 05:15:00	SPY	ETF	283.62	283.71	283.54	283.71	107900.0
2018-01-30 05:20:00	SPY	ETF	283.76	283.76	283.68	283.68	1700.0
2018-01-30 05:25:00	SPY	ETF	283.59	283.59	283.52	283.52	3550.0
2018-01-30 05:30:00	SPY	ETF	283.51	283.51	283.45	283.49	1006.0
2018-01-30 05:35:00	SPY	ETF	283.51	283.51	283.51	283.51	300.0
2018-01-30 05:40:00	SPY	ETF	283.47	283.47	283.47	283.47	300.0
2018-01-30 05:45:00	SPY	ETF	283.5	283.52	283.5	283.52	1000.0
2018-01-30 05:50:00	SPY	ETF	283.55	283.55	283.55	283.55	900.0
2018-01-30 05:55:00	SPY	ETF	283.57	283.57	283.42	283.47	3300.0
2018-01-30 06:05:00	SPY	ETF	283.4	283.42	283.34	283.4	3400.0
2018-01-30 06:10:00	SPY	ETF	283.5	283.51	283.5	283.51	700.0
2018-01-30 06:15:00	SPY	ETF	283.52	283.61	283.52	283.59	61400.0
2018-01-30 06:20:00	SPY	ETF	283.61	283.61	283.54	283.54	1900.0
2018-01-30 06:25:00	SPY	ETF	283.5	283.51	283.45	283.46	9056.0
2018-01-30 06:30:00	SPY	ETF	283.46	283.46	283.46	283.46	100.0
2018-01-30 06:35:00	SPY	ETF	283.51	283.51	283.45	283.51	2500.0
2018-01-30 06:40:00	SPY	ETF	283.45	283.49	283.45	283.49	1025.0
2018-01-30 06:45:00	SPY	ETF	283.55	283.55	283.49	283.51	29275.0
2018-01-30 06:50:00	SPY	ETF	283.5	283.5	283.44	283.48	23400.0
2018-01-30 06:55:00	SPY	ETF	283.44	283.44	283.41	283.41	915.0
2018-01-30 07:00:00	SPY	ETF	283.45	283.5	283.43	283.47	3040.0
2018-01-30 07:05:00	SPY	ETF	283.5	283.5	283.42	283.42	5402.0
2018-01-30 07:10:00	SPY	ETF	283.42	283.45	283.38	283.38	28596.0
2018-01-30 07:15:00	SPY	ETF	283.4	283.48	283.4	283.44	2813.0
2018-01-30 07:20:00	SPY	ETF	283.44	283.44	283.36	283.36	3715.0
2018-01-30 07:25:00	SPY	ETF	283.35	283.42	283.33	283.42	4780.0
2018-01-30 07:30:00	SPY	ETF	283.43	283.45	283.39	283.41	9219.0
2018-01-30 07:35:00	SPY	ETF	283.4	283.4	283.12	283.12	36543.0
2018-01-30 07:40:00	SPY	ETF	283.13	283.36	283.12	283.25	20233.0
2018-01-30 07:45:00	SPY	ETF	283.27	283.27	283.09	283.09	57533.0
2018-01-30 07:50:00	SPY	ETF	283.09	283.11	282.91	283.06	38319.0
2018-01-30 07:55:00	SPY	ETF	283.09	283.32	283.01	283.32	42240.0
2018-01-30 08:00:00	SPY	ETF	283.32	283.47	282.99	283.46	494470.0
2018-01-30 08:05:00	SPY	ETF	283.46	283.61	283.42	283.46	33212.0
2018-01-30 08:10:00	SPY	ETF	283.47	283.52	283.43	283.44	26601.0
2018-01-30 08:15:00	SPY	ETF	283.42	283.59	283.36	283.5	75158.0
2018-01-30 08:20:00	SPY	ETF	283.55	283.58	283.49	283.54	24763.0
2018-01-30 08:25:00	SPY	ETF	283.54	283.62	283.18	283.24	136053.0

> showing 50 of 66,702 rows — these rows as CSV

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