PREVIEW / etf_30min / 2017-10-03

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-03.parquet
  size:    440 KB
  rows:    15,176

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-10-03 04:00:00	SPY	ETF	252.45	252.45	252.43	252.43	810.0
2017-10-03 04:30:00	SPY	ETF	252.44	252.46	252.4	252.46	1800.0
2017-10-03 05:00:00	SPY	ETF	252.45	252.45	252.43	252.43	4200.0
2017-10-03 06:00:00	SPY	ETF	252.38	252.38	252.38	252.38	400.0
2017-10-03 06:30:00	SPY	ETF	252.4	252.5	252.39	252.43	3500.0
2017-10-03 07:00:00	SPY	ETF	252.43	252.44	252.4	252.4	25352.0
2017-10-03 07:30:00	SPY	ETF	252.39	252.45	252.38	252.45	18362.0
2017-10-03 08:00:00	SPY	ETF	252.42	252.53	252.4	252.51	77759.0
2017-10-03 08:30:00	SPY	ETF	252.52	252.53	252.46	252.5	110575.0
2017-10-03 09:00:00	SPY	ETF	252.5	252.54	252.46	252.47	372626.0
2017-10-03 09:30:00	SPY	ETF	252.46	252.58	252.27	252.52	4641200.0
2017-10-03 10:00:00	SPY	ETF	252.525	252.55	252.27	252.31	6565131.0
2017-10-03 10:30:00	SPY	ETF	252.31	252.46	252.285	252.39	5704456.0
2017-10-03 11:00:00	SPY	ETF	252.385	252.415	252.23	252.39	3678295.0
2017-10-03 11:30:00	SPY	ETF	252.395	252.5	252.35	252.47	2438817.0
2017-10-03 12:00:00	SPY	ETF	252.47	252.55	252.46	252.495	3044331.0
2017-10-03 12:30:00	SPY	ETF	252.5	252.58	252.47	252.58	1171928.0
2017-10-03 13:00:00	SPY	ETF	252.58	252.62	252.53	252.535	1644742.0
2017-10-03 13:30:00	SPY	ETF	252.535	252.59	252.51	252.575	1537003.0
2017-10-03 14:00:00	SPY	ETF	252.58	252.71	252.5734	252.7	3477358.0
2017-10-03 14:30:00	SPY	ETF	252.7	252.735	252.645	252.72	2535013.0
2017-10-03 15:00:00	SPY	ETF	252.71	252.72	252.63	252.72	3844867.0
2017-10-03 15:30:00	SPY	ETF	252.72	252.89	252.71	252.85	7147208.0
2017-10-03 16:00:00	SPY	ETF	252.85	252.98	252.77	252.86	14591545.0
2017-10-03 16:30:00	SPY	ETF	252.94	252.99	252.86	252.94	2764806.0
2017-10-03 17:00:00	SPY	ETF	252.93	252.94	252.92	252.94	125888.0
2017-10-03 17:30:00	SPY	ETF	252.94	252.96	252.92	252.96	31311.0
2017-10-03 18:00:00	SPY	ETF	252.95	252.98	252.85	252.85	84044.0
2017-10-03 18:30:00	SPY	ETF	252.87	252.88	252.8	252.84	25577.0
2017-10-03 19:00:00	SPY	ETF	252.86	252.88	252.83	252.84	5359.0
2017-10-03 19:30:00	SPY	ETF	252.84	252.84	252.82	252.82	42152.0
2017-10-03 04:00:00	QQQ	ETF	145.7	145.7	145.68	145.68	320.0
2017-10-03 05:00:00	QQQ	ETF	145.69	145.69	145.69	145.69	400.0
2017-10-03 06:00:00	QQQ	ETF	145.55	145.55	145.55	145.55	200.0
2017-10-03 06:30:00	QQQ	ETF	145.57	145.62	145.57	145.62	5100.0
2017-10-03 07:00:00	QQQ	ETF	145.64	145.64	145.55	145.55	5600.0
2017-10-03 07:30:00	QQQ	ETF	145.53	145.61	145.53	145.61	4120.0
2017-10-03 08:00:00	QQQ	ETF	145.61	145.76	145.58	145.7	64489.0
2017-10-03 08:30:00	QQQ	ETF	145.67	145.73	145.64	145.71	22565.0
2017-10-03 09:00:00	QQQ	ETF	145.72	145.79	145.72	145.75	67031.0
2017-10-03 09:30:00	QQQ	ETF	145.74	146.06	145.64	145.93	2880812.0
2017-10-03 10:00:00	QQQ	ETF	145.94	145.96	145.45	145.6399	1678669.0
2017-10-03 10:30:00	QQQ	ETF	145.64	145.88	145.58	145.8	1404781.0
2017-10-03 11:00:00	QQQ	ETF	145.79	145.86	145.63	145.82	828174.0
2017-10-03 11:30:00	QQQ	ETF	145.82	145.85	145.69	145.74	608490.0
2017-10-03 12:00:00	QQQ	ETF	145.75	145.93	145.74	145.85	707746.0
2017-10-03 12:30:00	QQQ	ETF	145.85	145.92	145.78	145.825	525651.0
2017-10-03 13:00:00	QQQ	ETF	145.83	145.8739	145.77	145.8045	538003.0
2017-10-03 13:30:00	QQQ	ETF	145.81	145.89	145.78	145.841	507197.0
2017-10-03 14:00:00	QQQ	ETF	145.84	145.9	145.8301	145.88	329770.0

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

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