PREVIEW / etf_30min / 2018-05-07

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-05-07.parquet
  size:    458 KB
  rows:    15,804

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-05-07 04:00:00	SPY	ETF	266.61	266.75	266.61	266.75	5008.0
2018-05-07 04:30:00	SPY	ETF	266.84	267.0	266.84	266.85	4414.0
2018-05-07 05:00:00	SPY	ETF	266.9	266.91	266.86	266.86	754.0
2018-05-07 05:30:00	SPY	ETF	266.81	266.98	266.75	266.86	5760.0
2018-05-07 06:00:00	SPY	ETF	266.9	266.92	266.74	266.74	6275.0
2018-05-07 06:30:00	SPY	ETF	266.77	267.11	266.77	267.02	36643.0
2018-05-07 07:00:00	SPY	ETF	267.03	267.25	267.03	267.11	109973.0
2018-05-07 07:30:00	SPY	ETF	267.15	267.4	266.93	266.99	99214.0
2018-05-07 08:00:00	SPY	ETF	266.99	267.31	266.6	266.9	198719.0
2018-05-07 08:30:00	SPY	ETF	266.88	267.07	266.76	267.03	151111.0
2018-05-07 09:00:00	SPY	ETF	267.03	267.12	266.89	266.91	230495.0
2018-05-07 09:30:00	SPY	ETF	266.89	267.78	266.63	267.74	6195976.0
2018-05-07 10:00:00	SPY	ETF	267.74	267.78	267.12	267.42	3560800.0
2018-05-07 10:30:00	SPY	ETF	267.415	267.47	266.75	267.425	3337857.0
2018-05-07 11:00:00	SPY	ETF	267.425	267.65	267.095	267.56	2223543.0
2018-05-07 11:30:00	SPY	ETF	267.56	267.6	267.1975	267.545	2395477.0
2018-05-07 12:00:00	SPY	ETF	267.55	267.74	267.355	267.62	1682866.0
2018-05-07 12:30:00	SPY	ETF	267.62	267.7	267.21	267.37	1533153.0
2018-05-07 13:00:00	SPY	ETF	267.37	267.49	267.09	267.45	1736406.0
2018-05-07 13:30:00	SPY	ETF	267.44	267.66	267.36	267.59	1493668.0
2018-05-07 14:00:00	SPY	ETF	267.58	267.85	267.515	267.83	1957309.0
2018-05-07 14:30:00	SPY	ETF	267.835	268.02	266.92	267.02	4643003.0
2018-05-07 15:00:00	SPY	ETF	267.0217	267.25	266.11	266.58	7118871.0
2018-05-07 15:30:00	SPY	ETF	266.57	266.99	266.43	266.91	8751173.0
2018-05-07 16:00:00	SPY	ETF	266.9	267.04	266.7632	266.83	5461513.0
2018-05-07 16:30:00	SPY	ETF	266.82	266.92	266.71	266.92	402585.0
2018-05-07 17:00:00	SPY	ETF	266.73	266.82	266.68	266.71	21881.0
2018-05-07 17:30:00	SPY	ETF	266.75	266.81	266.72	266.72	23921.0
2018-05-07 18:00:00	SPY	ETF	266.75	266.75	266.43	266.43	73455.0
2018-05-07 18:30:00	SPY	ETF	266.44	266.8	266.36	266.63	194104.0
2018-05-07 19:00:00	SPY	ETF	266.57	266.64	266.49	266.64	22207.0
2018-05-07 19:30:00	SPY	ETF	266.61	266.62	266.51	266.59	13369.0
2018-05-07 04:00:00	QQQ	ETF	165.6	165.77	165.6	165.77	11330.0
2018-05-07 04:30:00	QQQ	ETF	165.8	166.02	165.8	165.94	4600.0
2018-05-07 05:00:00	QQQ	ETF	165.87	166.0	165.87	165.91	2223.0
2018-05-07 05:30:00	QQQ	ETF	165.82	166.0	165.8	165.9	11450.0
2018-05-07 06:00:00	QQQ	ETF	165.85	165.85	165.7	165.7	8060.0
2018-05-07 06:30:00	QQQ	ETF	165.78	165.97	165.78	165.92	5950.0
2018-05-07 07:00:00	QQQ	ETF	165.85	165.98	165.85	165.91	57747.0
2018-05-07 07:30:00	QQQ	ETF	165.93	166.09	165.79	165.85	39334.0
2018-05-07 08:00:00	QQQ	ETF	166.04	166.04	165.69	165.73	97706.0
2018-05-07 08:30:00	QQQ	ETF	165.7	165.85	165.61	165.85	81850.0
2018-05-07 09:00:00	QQQ	ETF	165.84	165.88	165.63	165.65	306333.0
2018-05-07 09:30:00	QQQ	ETF	165.6	166.56	165.51	166.41	4658219.0
2018-05-07 10:00:00	QQQ	ETF	166.41	166.5	166.02	166.4661	2355958.0
2018-05-07 10:30:00	QQQ	ETF	166.46	166.6	165.98	166.45	1785971.0
2018-05-07 11:00:00	QQQ	ETF	166.45	166.72	166.19	166.66	1456042.0
2018-05-07 11:30:00	QQQ	ETF	166.67	166.7	166.34	166.6352	1043211.0
2018-05-07 12:00:00	QQQ	ETF	166.63	166.67	166.35	166.555	1061129.0
2018-05-07 12:30:00	QQQ	ETF	166.55	166.59	166.14	166.2601	981221.0

> showing 50 of 15,804 rows — these rows as CSV

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