PREVIEW / etf_30min / 2017-10-12

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-10-12.parquet
  size:    430 KB
  rows:    14,888

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-12 04:00:00	SPY	ETF	254.77	254.77	254.7	254.7	7100.0
2017-10-12 04:30:00	SPY	ETF	254.72	254.73	254.63	254.63	40900.0
2017-10-12 05:00:00	SPY	ETF	254.63	254.72	254.6	254.72	24200.0
2017-10-12 05:30:00	SPY	ETF	254.75	254.8	254.75	254.78	1650.0
2017-10-12 06:00:00	SPY	ETF	254.8	254.8	254.77	254.8	9200.0
2017-10-12 06:30:00	SPY	ETF	254.82	254.82	254.7	254.7	11100.0
2017-10-12 07:00:00	SPY	ETF	254.74	254.74	254.51	254.51	54330.0
2017-10-12 07:30:00	SPY	ETF	254.52	254.62	254.51	254.59	64206.0
2017-10-12 08:00:00	SPY	ETF	254.7	254.7	254.59	254.67	146517.0
2017-10-12 08:30:00	SPY	ETF	254.67	254.69	254.54	254.56	112295.0
2017-10-12 09:00:00	SPY	ETF	254.56	254.65	254.56	254.64	263114.0
2017-10-12 09:30:00	SPY	ETF	254.66	254.73	254.46	254.5676	4398459.0
2017-10-12 10:00:00	SPY	ETF	254.57	254.87	254.5	254.8	2642861.0
2017-10-12 10:30:00	SPY	ETF	254.81	254.959	254.75	254.8	3108227.0
2017-10-12 11:00:00	SPY	ETF	254.8	254.97	254.77	254.86	1371806.0
2017-10-12 11:30:00	SPY	ETF	254.86	255.03	254.851	255.01	1321983.0
2017-10-12 12:00:00	SPY	ETF	255.01	255.06	254.91	254.91	1129840.0
2017-10-12 12:30:00	SPY	ETF	254.91	254.93	254.78	254.88	1883846.0
2017-10-12 13:00:00	SPY	ETF	254.88	255.02	254.86	254.9803	1268950.0
2017-10-12 13:30:00	SPY	ETF	254.98	255.05	254.88	254.915	2060031.0
2017-10-12 14:00:00	SPY	ETF	254.915	254.97	254.85	254.9	1654074.0
2017-10-12 14:30:00	SPY	ETF	254.91	255.045	254.59	254.71	2866625.0
2017-10-12 15:00:00	SPY	ETF	254.71	254.86	254.67	254.76	3665033.0
2017-10-12 15:30:00	SPY	ETF	254.77	254.77	254.365	254.6	10439213.0
2017-10-12 16:00:00	SPY	ETF	254.6	254.7319	253.1659	254.64	6399797.0
2017-10-12 16:30:00	SPY	ETF	254.64	254.85	254.58	254.59	224006.0
2017-10-12 17:00:00	SPY	ETF	254.59	254.62	254.59	254.61	82239.0
2017-10-12 17:30:00	SPY	ETF	254.61	254.61	254.53	254.53	33434.0
2017-10-12 18:00:00	SPY	ETF	254.54	254.55	254.51	254.52	115664.0
2017-10-12 18:30:00	SPY	ETF	254.51	254.57	254.51	254.57	33691.0
2017-10-12 19:00:00	SPY	ETF	254.6	254.6	254.52	254.52	13125.0
2017-10-12 19:30:00	SPY	ETF	254.52	254.52	254.46	254.49	53342.0
2017-10-12 04:00:00	QQQ	ETF	147.95	147.95	147.95	147.95	100.0
2017-10-12 04:30:00	QQQ	ETF	147.93	147.93	147.87	147.88	15100.0
2017-10-12 05:00:00	QQQ	ETF	147.91	147.91	147.91	147.91	1900.0
2017-10-12 06:00:00	QQQ	ETF	147.97	147.97	147.97	147.97	400.0
2017-10-12 06:30:00	QQQ	ETF	147.99	147.99	147.95	147.95	1300.0
2017-10-12 07:00:00	QQQ	ETF	147.99	147.99	147.79	147.8	26910.0
2017-10-12 07:30:00	QQQ	ETF	147.82	147.88	147.79	147.86	22939.0
2017-10-12 08:00:00	QQQ	ETF	147.96	147.96	147.82	147.9	9384.0
2017-10-12 08:30:00	QQQ	ETF	147.88	147.88	147.75	147.76	25302.0
2017-10-12 09:00:00	QQQ	ETF	147.79	147.83	147.77	147.83	63059.0
2017-10-12 09:30:00	QQQ	ETF	147.85	148.005	147.66	147.9	2032617.0
2017-10-12 10:00:00	QQQ	ETF	147.9	148.11	147.77	148.04	1096013.0
2017-10-12 10:30:00	QQQ	ETF	148.05	148.16	147.95	148.0	971656.0
2017-10-12 11:00:00	QQQ	ETF	148.0	148.15	147.96	148.1	584129.0
2017-10-12 11:30:00	QQQ	ETF	148.1	148.22	148.08	148.2	667206.0
2017-10-12 12:00:00	QQQ	ETF	148.21	148.355	148.19	148.19	557703.0
2017-10-12 12:30:00	QQQ	ETF	148.1866	148.22	148.04	148.104	785332.0
2017-10-12 13:00:00	QQQ	ETF	148.1	148.23	148.09	148.1892	449167.0

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

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