PREVIEW / etf_30min / 2015-12-23

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-12-23.parquet
  size:    394 KB
  rows:    13,177

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
2015-12-23 04:00:00	SPY	ETF	204.08	204.35	204.08	204.26	13697.0
2015-12-23 04:30:00	SPY	ETF	204.25	204.43	204.25	204.39	8217.0
2015-12-23 05:00:00	SPY	ETF	204.39	204.45	204.28	204.39	19152.0
2015-12-23 05:30:00	SPY	ETF	204.37	204.44	204.32	204.32	8865.0
2015-12-23 06:00:00	SPY	ETF	204.24	204.64	204.19	204.57	44724.0
2015-12-23 06:30:00	SPY	ETF	204.53	204.65	204.49	204.58	35144.0
2015-12-23 07:00:00	SPY	ETF	204.61	204.95	204.57	204.89	106988.0
2015-12-23 07:30:00	SPY	ETF	204.89	204.91	204.69	204.74	114235.0
2015-12-23 08:00:00	SPY	ETF	204.74	204.89	204.57	204.69	239423.0
2015-12-23 08:30:00	SPY	ETF	204.7	204.72	204.55	204.6	318893.0
2015-12-23 09:00:00	SPY	ETF	204.6	204.83	204.6	204.73	486564.0
2015-12-23 09:30:00	SPY	ETF	204.69	205.0	204.58	204.86	11064382.0
2015-12-23 10:00:00	SPY	ETF	204.86	205.11	204.67	204.69	7368647.0
2015-12-23 10:30:00	SPY	ETF	204.69	205.37	204.65	205.35	9157396.0
2015-12-23 11:00:00	SPY	ETF	205.35	205.38	205.1	205.23	4474771.0
2015-12-23 11:30:00	SPY	ETF	205.225	205.35	205.13	205.311	5360139.0
2015-12-23 12:00:00	SPY	ETF	205.32	205.7	205.3	205.56	8171623.0
2015-12-23 12:30:00	SPY	ETF	205.56	205.61	205.38	205.47	3975020.0
2015-12-23 13:00:00	SPY	ETF	205.47	205.54	205.28	205.385	3801621.0
2015-12-23 13:30:00	SPY	ETF	205.38	205.55	205.13	205.5062	5088419.0
2015-12-23 14:00:00	SPY	ETF	205.5	205.86	205.43	205.79	7773641.0
2015-12-23 14:30:00	SPY	ETF	205.79	206.07	205.775	205.94	8794351.0
2015-12-23 15:00:00	SPY	ETF	205.93	206.03	205.75	205.81	8088456.0
2015-12-23 15:30:00	SPY	ETF	205.805	206.07	205.55	206.02	15972825.0
2015-12-23 16:00:00	SPY	ETF	206.02	206.08	205.52	205.73	4308156.0
2015-12-23 16:30:00	SPY	ETF	205.69	205.75	205.62	205.64	3182053.0
2015-12-23 17:00:00	SPY	ETF	205.64	205.69	205.61	205.69	33557.0
2015-12-23 17:30:00	SPY	ETF	205.65	205.73	205.5	205.63	63897.0
2015-12-23 18:00:00	SPY	ETF	205.69	205.72	205.56	205.67	39714.0
2015-12-23 18:30:00	SPY	ETF	205.65	205.74	205.65	205.67	9547.0
2015-12-23 19:00:00	SPY	ETF	205.68	205.9	205.61	205.88	49339.0
2015-12-23 19:30:00	SPY	ETF	205.9	205.94	205.86	205.89	15116.0
2015-12-23 04:00:00	QQQ	ETF	112.1	112.2	112.1	112.2	260.0
2015-12-23 04:30:00	QQQ	ETF	112.19	112.19	112.19	112.19	500.0
2015-12-23 05:00:00	QQQ	ETF	112.23	112.24	112.22	112.24	12700.0
2015-12-23 05:30:00	QQQ	ETF	112.25	112.25	112.25	112.25	100.0
2015-12-23 06:00:00	QQQ	ETF	112.27	112.3	112.27	112.3	450.0
2015-12-23 06:30:00	QQQ	ETF	112.32	112.32	112.32	112.32	200.0
2015-12-23 07:00:00	QQQ	ETF	112.36	112.49	112.36	112.47	32157.0
2015-12-23 07:30:00	QQQ	ETF	112.45	112.46	112.35	112.35	58766.0
2015-12-23 08:00:00	QQQ	ETF	112.36	112.47	112.31	112.33	25900.0
2015-12-23 08:30:00	QQQ	ETF	112.35	112.39	112.32	112.33	52185.0
2015-12-23 09:00:00	QQQ	ETF	112.34	112.44	112.335	112.36	224711.0
2015-12-23 09:30:00	QQQ	ETF	112.35	112.52	112.21	112.468	3265907.0
2015-12-23 10:00:00	QQQ	ETF	112.46	112.59	112.2248	112.2499	2429118.0
2015-12-23 10:30:00	QQQ	ETF	112.25	112.47	112.2	112.41	2034170.0
2015-12-23 11:00:00	QQQ	ETF	112.41	112.43	112.17	112.22	1011665.0
2015-12-23 11:30:00	QQQ	ETF	112.22	112.39	112.209	112.38	1001971.0
2015-12-23 12:00:00	QQQ	ETF	112.37	112.48	112.34	112.38	994158.0
2015-12-23 12:30:00	QQQ	ETF	112.38	112.4	112.23	112.29	792181.0

> showing 50 of 13,177 rows — these rows as CSV

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