PREVIEW / etf_30min / 2017-03-15

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-15.parquet
  size:    438 KB
  rows:    14,812

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
2017-03-15 04:00:00	SPY	ETF	237.32	237.54	237.32	237.54	2665.0
2017-03-15 04:30:00	SPY	ETF	237.56	237.64	237.56	237.64	12980.0
2017-03-15 05:00:00	SPY	ETF	237.63	237.63	237.5	237.52	9107.0
2017-03-15 05:30:00	SPY	ETF	237.57	237.57	237.47	237.47	10560.0
2017-03-15 06:00:00	SPY	ETF	237.49	237.5	237.45	237.45	1656.0
2017-03-15 06:30:00	SPY	ETF	237.43	237.49	237.4	237.4	4524.0
2017-03-15 07:00:00	SPY	ETF	237.48	237.6	237.45	237.58	29109.0
2017-03-15 07:30:00	SPY	ETF	237.59	237.59	237.42	237.45	35953.0
2017-03-15 08:00:00	SPY	ETF	237.44	237.56	237.4	237.4	180987.0
2017-03-15 08:30:00	SPY	ETF	237.42	237.6	237.42	237.6	151855.0
2017-03-15 09:00:00	SPY	ETF	237.58	237.63	237.48	237.55	229583.0
2017-03-15 09:30:00	SPY	ETF	237.56	237.63	237.29	237.555	4814179.0
2017-03-15 10:00:00	SPY	ETF	237.56	237.72	237.435	237.719	3379581.0
2017-03-15 10:30:00	SPY	ETF	237.72	237.76	237.47	237.58	2680907.0
2017-03-15 11:00:00	SPY	ETF	237.57	237.76	237.57	237.702	2682407.0
2017-03-15 11:30:00	SPY	ETF	237.71	237.82	237.65	237.745	2133683.0
2017-03-15 12:00:00	SPY	ETF	237.745	237.89	237.74	237.8599	1864710.0
2017-03-15 12:30:00	SPY	ETF	237.85	238.15	237.84	238.075	3626686.0
2017-03-15 13:00:00	SPY	ETF	238.08	238.15	237.79	237.85	2547287.0
2017-03-15 13:30:00	SPY	ETF	237.85	237.91	237.75	237.79	2292419.0
2017-03-15 14:00:00	SPY	ETF	237.81	238.79	237.77	238.47	12110850.0
2017-03-15 14:30:00	SPY	ETF	238.47	239.05	238.22	238.83	8666357.0
2017-03-15 15:00:00	SPY	ETF	238.83	239.15	238.71	239.12	10281420.0
2017-03-15 15:30:00	SPY	ETF	239.115	239.44	238.84	238.89	18395384.0
2017-03-15 16:00:00	SPY	ETF	238.88	238.95	238.57	238.75	10862342.0
2017-03-15 16:30:00	SPY	ETF	238.77	238.78	238.52	238.65	803728.0
2017-03-15 17:00:00	SPY	ETF	238.66	238.95	238.64	238.73	577794.0
2017-03-15 17:30:00	SPY	ETF	238.73	238.78	238.71	238.72	196707.0
2017-03-15 18:00:00	SPY	ETF	238.72	238.77	238.56	238.75	784502.0
2017-03-15 18:30:00	SPY	ETF	238.78	238.8	238.73	238.79	7998.0
2017-03-15 19:00:00	SPY	ETF	238.8	238.85	238.74	238.81	24036.0
2017-03-15 19:30:00	SPY	ETF	238.81	238.92	238.8	238.92	37272.0
2017-03-15 04:00:00	QQQ	ETF	131.42	131.58	131.39	131.56	1150.0
2017-03-15 04:30:00	QQQ	ETF	131.56	131.56	131.56	131.56	100.0
2017-03-15 05:00:00	QQQ	ETF	131.55	131.55	131.51	131.51	4127.0
2017-03-15 05:30:00	QQQ	ETF	131.56	131.57	131.56	131.57	15000.0
2017-03-15 06:00:00	QQQ	ETF	131.51	131.52	131.51	131.52	1650.0
2017-03-15 06:30:00	QQQ	ETF	131.45	131.47	131.45	131.47	1573.0
2017-03-15 07:00:00	QQQ	ETF	131.49	131.52	131.49	131.52	5200.0
2017-03-15 07:30:00	QQQ	ETF	131.56	131.58	131.49	131.49	22450.0
2017-03-15 08:00:00	QQQ	ETF	131.49	131.57	131.49	131.5	23942.0
2017-03-15 08:30:00	QQQ	ETF	131.49	131.53	131.49	131.52	14150.0
2017-03-15 09:00:00	QQQ	ETF	131.54	131.6	131.51	131.56	94702.0
2017-03-15 09:30:00	QQQ	ETF	131.58	131.58	131.26	131.33	1027879.0
2017-03-15 10:00:00	QQQ	ETF	131.34	131.36	131.14	131.305	1057182.0
2017-03-15 10:30:00	QQQ	ETF	131.31	131.33	131.18	131.23	961290.0
2017-03-15 11:00:00	QQQ	ETF	131.23	131.36	131.22	131.34	565598.0
2017-03-15 11:30:00	QQQ	ETF	131.34	131.4	131.32	131.38	507269.0
2017-03-15 12:00:00	QQQ	ETF	131.38	131.49	131.37	131.48	375667.0
2017-03-15 12:30:00	QQQ	ETF	131.475	131.68	131.47	131.64	995045.0

> showing 50 of 14,812 rows — these rows as CSV

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