PREVIEW / etf_30min / 2018-03-15

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-15.parquet
  size:    452 KB
  rows:    15,534

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-03-15 04:00:00	SPY	ETF	275.92	276.18	275.67	275.67	13368.0
2018-03-15 04:30:00	SPY	ETF	275.69	275.69	275.6	275.64	1166.0
2018-03-15 05:00:00	SPY	ETF	275.88	275.99	275.88	275.88	9420.0
2018-03-15 05:30:00	SPY	ETF	275.93	275.94	275.78	275.8	12400.0
2018-03-15 06:00:00	SPY	ETF	275.62	275.62	275.33	275.45	12515.0
2018-03-15 06:30:00	SPY	ETF	275.44	275.44	275.13	275.13	24124.0
2018-03-15 07:00:00	SPY	ETF	275.18	275.43	275.12	275.42	72259.0
2018-03-15 07:30:00	SPY	ETF	275.41	275.6	275.32	275.42	134086.0
2018-03-15 08:00:00	SPY	ETF	275.21	275.99	275.21	275.37	100433.0
2018-03-15 08:30:00	SPY	ETF	275.35	275.8	275.32	275.65	138620.0
2018-03-15 09:00:00	SPY	ETF	275.66	275.9	275.55	275.87	245396.0
2018-03-15 09:30:00	SPY	ETF	275.88	275.98	275.02	275.255	5825108.0
2018-03-15 10:00:00	SPY	ETF	275.26	275.92	275.23	275.68	4587575.0
2018-03-15 10:30:00	SPY	ETF	275.67	275.9	275.31	275.72	3863530.0
2018-03-15 11:00:00	SPY	ETF	275.73	276.61	275.7	276.39	5018794.0
2018-03-15 11:30:00	SPY	ETF	276.39	276.46	275.48	275.81	4563337.0
2018-03-15 12:00:00	SPY	ETF	275.82	276.07	275.69	275.72	2897631.0
2018-03-15 12:30:00	SPY	ETF	275.72	275.86	275.45	275.585	3877165.0
2018-03-15 13:00:00	SPY	ETF	275.58	275.77	275.25	275.5495	2562024.0
2018-03-15 13:30:00	SPY	ETF	275.54	275.66	274.55	274.5575	4774580.0
2018-03-15 14:00:00	SPY	ETF	274.56	275.09	274.43	274.73	4889085.0
2018-03-15 14:30:00	SPY	ETF	274.73	275.07	274.52	275.06	4846118.0
2018-03-15 15:00:00	SPY	ETF	275.06	275.31	274.7	275.29	5773866.0
2018-03-15 15:30:00	SPY	ETF	275.299	275.39	275.0	275.01	9146826.0
2018-03-15 16:00:00	SPY	ETF	275.01	275.56	274.97	275.36	11489476.0
2018-03-15 16:30:00	SPY	ETF	275.38	275.65	274.9022	275.57	515062.0
2018-03-15 17:00:00	SPY	ETF	275.63	275.64	275.51	275.57	70398.0
2018-03-15 17:30:00	SPY	ETF	275.57	275.57	275.0	275.49	545111.0
2018-03-15 18:00:00	SPY	ETF	275.5	275.64	275.0	275.57	2219283.0
2018-03-15 18:30:00	SPY	ETF	275.57	275.59	275.5	275.5	16273.0
2018-03-15 19:00:00	SPY	ETF	275.5	275.68	275.49	275.62	33620.0
2018-03-15 19:30:00	SPY	ETF	275.67	275.69	275.62	275.67	21840.0
2018-03-15 04:00:00	QQQ	ETF	171.84	171.85	171.71	171.72	19880.0
2018-03-15 04:30:00	QQQ	ETF	171.71	171.71	171.7	171.7	1100.0
2018-03-15 05:00:00	QQQ	ETF	171.62	171.89	171.62	171.86	4900.0
2018-03-15 05:30:00	QQQ	ETF	171.83	171.83	171.76	171.79	11751.0
2018-03-15 06:00:00	QQQ	ETF	171.79	171.79	171.48	171.54	7096.0
2018-03-15 06:30:00	QQQ	ETF	171.5	171.54	171.32	171.39	29200.0
2018-03-15 07:00:00	QQQ	ETF	171.39	171.45	171.29	171.45	109174.0
2018-03-15 07:30:00	QQQ	ETF	171.45	171.56	171.37	171.45	44675.0
2018-03-15 08:00:00	QQQ	ETF	171.39	171.75	171.31	171.42	51819.0
2018-03-15 08:30:00	QQQ	ETF	171.39	171.73	171.38	171.63	129345.0
2018-03-15 09:00:00	QQQ	ETF	171.63	171.87	171.6	171.84	97472.0
2018-03-15 09:30:00	QQQ	ETF	171.83	171.91	171.03	171.45	2612176.0
2018-03-15 10:00:00	QQQ	ETF	171.4524	171.89	171.45	171.85	1857953.0
2018-03-15 10:30:00	QQQ	ETF	171.86	172.091	171.61	172.0	1486200.0
2018-03-15 11:00:00	QQQ	ETF	172.02	172.53	172.02	172.43	2028688.0
2018-03-15 11:30:00	QQQ	ETF	172.44	172.46	171.95	172.09	1579557.0
2018-03-15 12:00:00	QQQ	ETF	172.1199	172.179	171.79	171.85	1215111.0
2018-03-15 12:30:00	QQQ	ETF	171.86	172.03	171.63	171.84	1111308.0

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

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