PREVIEW / etf_30min / 2018-10-11

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-10-11.parquet
  size:    535 KB
  rows:    18,726

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-11 04:00:00	SPY	ETF	275.29	275.35	274.5	275.3	131883.0
2018-10-11 04:30:00	SPY	ETF	275.27	275.36	274.45	274.65	108316.0
2018-10-11 05:00:00	SPY	ETF	274.57	274.85	273.82	274.8	260072.0
2018-10-11 05:30:00	SPY	ETF	274.73	275.22	274.34	275.0	107069.0
2018-10-11 06:00:00	SPY	ETF	274.93	275.39	274.66	274.86	104892.0
2018-10-11 06:30:00	SPY	ETF	274.87	275.16	274.5	275.08	143313.0
2018-10-11 07:00:00	SPY	ETF	275.08	275.43	274.92	275.21	761119.0
2018-10-11 07:30:00	SPY	ETF	275.21	276.06	274.72	275.77	802139.0
2018-10-11 08:00:00	SPY	ETF	275.0	277.97	274.01	276.38	1551027.0
2018-10-11 08:30:00	SPY	ETF	276.37	277.7	276.35	277.05	2420243.0
2018-10-11 09:00:00	SPY	ETF	277.08	277.6	276.89	277.11	1235332.0
2018-10-11 09:30:00	SPY	ETF	277.08	278.9	276.21	278.7762	25472030.0
2018-10-11 10:00:00	SPY	ETF	278.77	278.79	276.56	277.25	16480119.0
2018-10-11 10:30:00	SPY	ETF	277.25	277.7667	275.7	275.79	13966094.0
2018-10-11 11:00:00	SPY	ETF	275.81	275.93	273.91	275.24	24342571.0
2018-10-11 11:30:00	SPY	ETF	275.24	276.88	274.49	276.12	21496454.0
2018-10-11 12:00:00	SPY	ETF	276.1	277.82	275.81	277.14	11580862.0
2018-10-11 12:30:00	SPY	ETF	277.125	277.27	275.99	276.38	6242817.0
2018-10-11 13:00:00	SPY	ETF	276.38	276.9	275.5	276.3999	7071438.0
2018-10-11 13:30:00	SPY	ETF	276.39	276.7126	274.9	275.99	7096084.0
2018-10-11 14:00:00	SPY	ETF	275.97	276.14	274.29	274.51	13471147.0
2018-10-11 14:30:00	SPY	ETF	274.51	274.55	270.36	272.49	31011026.0
2018-10-11 15:00:00	SPY	ETF	272.49	275.7	272.0	274.64	27765910.0
2018-10-11 15:30:00	SPY	ETF	274.65	275.21	272.21	272.25	37265773.0
2018-10-11 16:00:00	SPY	ETF	272.26	274.45	271.8	273.78	18087194.0
2018-10-11 16:30:00	SPY	ETF	273.9	274.54	272.17	273.83	881989.0
2018-10-11 17:00:00	SPY	ETF	273.89	273.92	272.17	273.69	140606.0
2018-10-11 17:30:00	SPY	ETF	273.7	274.0499	273.59	273.93	208137.0
2018-10-11 18:00:00	SPY	ETF	273.9	277.08	273.7	274.38	145895.0
2018-10-11 18:30:00	SPY	ETF	274.38	274.86	273.65	274.79	1392747.0
2018-10-11 19:00:00	SPY	ETF	274.8	275.38	272.17	275.2	238567.0
2018-10-11 19:30:00	SPY	ETF	275.07	275.11	274.67	274.8	72156.0
2018-10-11 04:00:00	QQQ	ETF	169.75	170.1	169.5	170.03	26770.0
2018-10-11 04:30:00	QQQ	ETF	170.0	170.04	169.28	169.41	59069.0
2018-10-11 05:00:00	QQQ	ETF	169.35	169.59	168.87	169.48	76737.0
2018-10-11 05:30:00	QQQ	ETF	169.41	169.97	169.09	169.55	32812.0
2018-10-11 06:00:00	QQQ	ETF	169.63	169.89	169.24	169.39	47377.0
2018-10-11 06:30:00	QQQ	ETF	169.38	169.72	169.18	169.64	100412.0
2018-10-11 07:00:00	QQQ	ETF	169.67	169.78	169.35	169.55	262249.0
2018-10-11 07:30:00	QQQ	ETF	169.48	170.06	168.91	169.88	850915.0
2018-10-11 08:00:00	QQQ	ETF	169.55	170.97	168.55	170.14	1184515.0
2018-10-11 08:30:00	QQQ	ETF	170.18	171.3	170.17	170.71	2376949.0
2018-10-11 09:00:00	QQQ	ETF	170.78	171.67	170.7	171.07	1310987.0
2018-10-11 09:30:00	QQQ	ETF	171.04	173.4	170.07	173.33	19782154.0
2018-10-11 10:00:00	QQQ	ETF	173.33	173.33	170.94	171.88	11447625.0
2018-10-11 10:30:00	QQQ	ETF	171.89	172.39	170.64	170.78	7094967.0
2018-10-11 11:00:00	QQQ	ETF	170.77	171.1	169.47	170.83	9764002.0
2018-10-11 11:30:00	QQQ	ETF	170.84	172.31	170.09	171.42	8816736.0
2018-10-11 12:00:00	QQQ	ETF	171.4199	172.9	171.2899	172.2	4398956.0
2018-10-11 12:30:00	QQQ	ETF	172.19	172.32	171.27	171.81	3223621.0

> showing 50 of 18,726 rows — these rows as CSV

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