PREVIEW / etf_30min / 2018-08-30

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-08-30.parquet
  size:    474 KB
  rows:    16,243

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-08-30 04:00:00	SPY	ETF	291.19	291.19	290.9	290.9	13446.0
2018-08-30 04:30:00	SPY	ETF	290.9	290.95	290.74	290.84	52127.0
2018-08-30 05:00:00	SPY	ETF	290.95	290.95	290.86	290.92	12852.0
2018-08-30 05:30:00	SPY	ETF	290.87	291.0	290.87	290.91	6500.0
2018-08-30 06:00:00	SPY	ETF	290.96	290.96	290.81	290.86	7600.0
2018-08-30 06:30:00	SPY	ETF	290.86	291.17	290.84	290.97	44552.0
2018-08-30 07:00:00	SPY	ETF	291.07	291.12	290.96	291.08	54620.0
2018-08-30 07:30:00	SPY	ETF	291.1	291.17	290.93	290.99	129241.0
2018-08-30 08:00:00	SPY	ETF	291.0001	291.17	290.92	291.09	85039.0
2018-08-30 08:30:00	SPY	ETF	291.1	291.26	291.0	291.01	213400.0
2018-08-30 09:00:00	SPY	ETF	291.02	291.1	290.82	290.93	365550.0
2018-08-30 09:30:00	SPY	ETF	290.94	291.2	290.78	290.88	4722484.0
2018-08-30 10:00:00	SPY	ETF	290.87	291.235	290.86	291.06	3216465.0
2018-08-30 10:30:00	SPY	ETF	291.06	291.36	290.91	291.11	2761702.0
2018-08-30 11:00:00	SPY	ETF	291.11	291.32	290.48	290.615	4867276.0
2018-08-30 11:30:00	SPY	ETF	290.615	290.765	290.52	290.66	2830137.0
2018-08-30 12:00:00	SPY	ETF	290.67	290.91	290.59	290.8899	2223322.0
2018-08-30 12:30:00	SPY	ETF	290.88	291.18	290.855	291.14	2591261.0
2018-08-30 13:00:00	SPY	ETF	291.14	291.32	291.1	291.275	2954839.0
2018-08-30 13:30:00	SPY	ETF	291.28	291.34	291.19	291.23	1807529.0
2018-08-30 14:00:00	SPY	ETF	291.24	291.34	289.88	290.19	7132588.0
2018-08-30 14:30:00	SPY	ETF	290.2	290.65	290.083	290.083	4602380.0
2018-08-30 15:00:00	SPY	ETF	290.09	290.15	289.63	290.1	4018544.0
2018-08-30 15:30:00	SPY	ETF	290.105	290.37	289.93	290.24	9913548.0
2018-08-30 16:00:00	SPY	ETF	290.26	290.4	290.22	290.26	5176799.0
2018-08-30 16:30:00	SPY	ETF	290.27	290.3	289.96	289.97	189800.0
2018-08-30 17:00:00	SPY	ETF	290.02	290.02	289.9	289.91	49022.0
2018-08-30 17:30:00	SPY	ETF	290.02	290.03	289.91	289.96	12547.0
2018-08-30 18:00:00	SPY	ETF	289.92	289.99	289.69	289.72	52673.0
2018-08-30 18:30:00	SPY	ETF	289.8	289.83	289.75	289.8	18034.0
2018-08-30 19:00:00	SPY	ETF	289.84	290.0	289.84	289.96	15572.0
2018-08-30 19:30:00	SPY	ETF	289.96	289.97	289.84	289.86	5220.0
2018-08-30 04:00:00	QQQ	ETF	186.6	186.6	186.4	186.4	6332.0
2018-08-30 04:30:00	QQQ	ETF	186.42	186.43	186.33	186.42	5680.0
2018-08-30 05:00:00	QQQ	ETF	186.41	186.42	186.37	186.4	28185.0
2018-08-30 05:30:00	QQQ	ETF	186.39	186.48	186.38	186.38	20543.0
2018-08-30 06:00:00	QQQ	ETF	186.41	186.46	186.34	186.37	8950.0
2018-08-30 06:30:00	QQQ	ETF	186.34	186.56	186.32	186.45	28697.0
2018-08-30 07:00:00	QQQ	ETF	186.53	186.53	186.44	186.49	21138.0
2018-08-30 07:30:00	QQQ	ETF	186.5	186.54	186.45	186.45	52170.0
2018-08-30 08:00:00	QQQ	ETF	186.5001	186.62	186.42	186.62	95459.0
2018-08-30 08:30:00	QQQ	ETF	186.55	186.67	186.44	186.44	101518.0
2018-08-30 09:00:00	QQQ	ETF	186.43	186.54	186.34	186.42	120634.0
2018-08-30 09:30:00	QQQ	ETF	186.41	186.67	186.18	186.33	2542551.0
2018-08-30 10:00:00	QQQ	ETF	186.33	186.769	186.32	186.69	1629079.0
2018-08-30 10:30:00	QQQ	ETF	186.68	187.12	186.55	186.9063	1387897.0
2018-08-30 11:00:00	QQQ	ETF	186.91	187.115	186.55	186.64	2577620.0
2018-08-30 11:30:00	QQQ	ETF	186.635	186.89	186.54	186.84	1475183.0
2018-08-30 12:00:00	QQQ	ETF	186.85	187.138	186.83	187.075	854006.0
2018-08-30 12:30:00	QQQ	ETF	187.08	187.41	187.06	187.361	1088600.0

> showing 50 of 16,243 rows — these rows as CSV

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