PREVIEW / etf_30min / 2018-01-18

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-18.parquet
  size:    484 KB
  rows:    16,737

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-18 04:00:00	SPY	ETF	279.32	279.53	279.29	279.29	23990.0
2018-01-18 04:30:00	SPY	ETF	279.34	279.52	279.34	279.52	9200.0
2018-01-18 05:00:00	SPY	ETF	279.42	279.42	279.32	279.38	2620.0
2018-01-18 05:30:00	SPY	ETF	279.41	279.54	279.41	279.54	7340.0
2018-01-18 06:00:00	SPY	ETF	279.54	279.74	279.49	279.74	7580.0
2018-01-18 06:30:00	SPY	ETF	279.75	279.86	279.68	279.86	20463.0
2018-01-18 07:00:00	SPY	ETF	279.87	279.95	279.78	279.79	74546.0
2018-01-18 07:30:00	SPY	ETF	279.79	279.79	279.48	279.49	47830.0
2018-01-18 08:00:00	SPY	ETF	279.54	279.86	279.3	279.54	121396.0
2018-01-18 08:30:00	SPY	ETF	279.52	279.57	279.2	279.36	271755.0
2018-01-18 09:00:00	SPY	ETF	279.35	279.53	279.21	279.48	483835.0
2018-01-18 09:30:00	SPY	ETF	279.48	279.825	279.16	279.62	5498430.0
2018-01-18 10:00:00	SPY	ETF	279.63	279.66	278.76	279.095	6133295.0
2018-01-18 10:30:00	SPY	ETF	279.09	279.5977	279.04	279.04	9261340.0
2018-01-18 11:00:00	SPY	ETF	279.04	279.5	278.87	279.015	4861672.0
2018-01-18 11:30:00	SPY	ETF	279.02	279.5977	278.58	278.91	6811353.0
2018-01-18 12:00:00	SPY	ETF	278.92	279.3	278.87	279.24	3959642.0
2018-01-18 12:30:00	SPY	ETF	279.25	279.35	279.15	279.22	1939763.0
2018-01-18 13:00:00	SPY	ETF	279.22	279.36	278.96	279.1653	2697230.0
2018-01-18 13:30:00	SPY	ETF	279.17	279.48	279.08	279.435	2335639.0
2018-01-18 14:00:00	SPY	ETF	279.44	279.82	279.39	279.799	13253096.0
2018-01-18 14:30:00	SPY	ETF	279.8	279.96	279.55	279.665	4607259.0
2018-01-18 15:00:00	SPY	ETF	279.67	279.72	279.28	279.33	3447594.0
2018-01-18 15:30:00	SPY	ETF	279.32	279.34	278.86	279.18	17189827.0
2018-01-18 16:00:00	SPY	ETF	279.17	279.33	278.75	278.79	10492383.0
2018-01-18 16:30:00	SPY	ETF	278.84	278.87	278.63	278.87	2108520.0
2018-01-18 17:00:00	SPY	ETF	278.8	279.14	278.8	278.86	203638.0
2018-01-18 17:30:00	SPY	ETF	278.86	278.88	278.82	278.86	52001.0
2018-01-18 18:00:00	SPY	ETF	278.9	279.19	278.9	279.16	234944.0
2018-01-18 18:30:00	SPY	ETF	279.18	279.22	279.04	279.04	15620.0
2018-01-18 19:00:00	SPY	ETF	279.04	279.06	278.93	278.94	9881.0
2018-01-18 19:30:00	SPY	ETF	278.95	279.08	278.93	278.97	26630.0
2018-01-18 04:00:00	QQQ	ETF	165.54	165.58	165.47	165.5	17100.0
2018-01-18 04:30:00	QQQ	ETF	165.5	165.53	165.48	165.52	2190.0
2018-01-18 05:00:00	QQQ	ETF	165.53	165.54	165.47	165.48	5100.0
2018-01-18 05:30:00	QQQ	ETF	165.5	165.59	165.5	165.59	3800.0
2018-01-18 06:00:00	QQQ	ETF	165.61	165.69	165.61	165.68	7800.0
2018-01-18 06:30:00	QQQ	ETF	165.69	165.72	165.68	165.7	3200.0
2018-01-18 07:00:00	QQQ	ETF	165.77	165.81	165.71	165.76	2100.0
2018-01-18 07:30:00	QQQ	ETF	165.71	165.71	165.45	165.49	19941.0
2018-01-18 08:00:00	QQQ	ETF	165.79	165.8	165.24	165.49	188775.0
2018-01-18 08:30:00	QQQ	ETF	165.4	165.52	165.24	165.34	192615.0
2018-01-18 09:00:00	QQQ	ETF	165.33	165.61	165.22	165.55	164311.0
2018-01-18 09:30:00	QQQ	ETF	165.55	165.89	165.47	165.71	3433601.0
2018-01-18 10:00:00	QQQ	ETF	165.71	165.73	165.135	165.44	2731190.0
2018-01-18 10:30:00	QQQ	ETF	165.435	165.81	165.419	165.53	1498140.0
2018-01-18 11:00:00	QQQ	ETF	165.53	165.94	165.47	165.65	1638574.0
2018-01-18 11:30:00	QQQ	ETF	165.65	165.81	165.35	165.605	1050303.0
2018-01-18 12:00:00	QQQ	ETF	165.6	165.935	165.575	165.93	550391.0
2018-01-18 12:30:00	QQQ	ETF	165.93	166.03	165.87	165.9	664553.0

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

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