PREVIEW / etf_30min / 2017-08-03

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-08-03.parquet
  size:    425 KB
  rows:    14,755

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-08-03 04:00:00	SPY	ETF	246.91	247.05	246.91	247.05	13700.0
2017-08-03 04:30:00	SPY	ETF	247.11	247.11	247.11	247.11	2020.0
2017-08-03 05:00:00	SPY	ETF	247.29	247.29	247.29	247.29	1250.0
2017-08-03 05:30:00	SPY	ETF	247.14	247.14	247.14	247.14	100.0
2017-08-03 06:00:00	SPY	ETF	247.19	247.2	247.16	247.17	25800.0
2017-08-03 06:30:00	SPY	ETF	247.25	247.39	247.25	247.31	22300.0
2017-08-03 07:00:00	SPY	ETF	247.31	247.31	247.2	247.21	30200.0
2017-08-03 07:30:00	SPY	ETF	247.18	247.3	247.11	247.29	51848.0
2017-08-03 08:00:00	SPY	ETF	247.24	247.34	247.16	247.31	143615.0
2017-08-03 08:30:00	SPY	ETF	247.34	247.48	247.27	247.46	105735.0
2017-08-03 09:00:00	SPY	ETF	247.46	247.46	247.31	247.32	103702.0
2017-08-03 09:30:00	SPY	ETF	247.31	247.34	246.91	246.99	3761266.0
2017-08-03 10:00:00	SPY	ETF	246.99	247.22	246.84	247.22	3182734.0
2017-08-03 10:30:00	SPY	ETF	247.22	247.29	247.11	247.23	2648754.0
2017-08-03 11:00:00	SPY	ETF	247.23	247.31	247.05	247.07	1741548.0
2017-08-03 11:30:00	SPY	ETF	247.07	247.0701	246.93	246.95	2148999.0
2017-08-03 12:00:00	SPY	ETF	246.95	247.13	246.9	247.1	1500763.0
2017-08-03 12:30:00	SPY	ETF	247.1	247.12	246.96	247.01	1588034.0
2017-08-03 13:00:00	SPY	ETF	247.0133	247.0599	246.86	246.93	1374753.0
2017-08-03 13:30:00	SPY	ETF	246.93	247.17	246.79	247.1	2546383.0
2017-08-03 14:00:00	SPY	ETF	247.1	247.17	247.05	247.15	1196780.0
2017-08-03 14:30:00	SPY	ETF	247.15	247.18	246.97	247.005	1360980.0
2017-08-03 15:00:00	SPY	ETF	247.005	247.23	246.99	247.2	1862633.0
2017-08-03 15:30:00	SPY	ETF	247.19	247.2	246.64	246.98	8869295.0
2017-08-03 16:00:00	SPY	ETF	246.97	247.31	246.94	247.18	4546703.0
2017-08-03 16:30:00	SPY	ETF	247.18	247.21	246.99	247.08	288079.0
2017-08-03 17:00:00	SPY	ETF	247.08	247.14	246.96	247.06	268212.0
2017-08-03 17:30:00	SPY	ETF	247.06	247.11	247.04	247.11	19912.0
2017-08-03 18:00:00	SPY	ETF	247.05	247.12	247.05	247.08	44438.0
2017-08-03 18:30:00	SPY	ETF	247.06	247.07	247.01	247.06	19179.0
2017-08-03 19:00:00	SPY	ETF	247.06	247.06	246.96	246.98	26920.0
2017-08-03 19:30:00	SPY	ETF	246.98	246.98	246.88	246.91	25243.0
2017-08-03 04:00:00	QQQ	ETF	143.69	143.78	143.67	143.78	870.0
2017-08-03 04:30:00	QQQ	ETF	143.75	143.75	143.75	143.75	2000.0
2017-08-03 05:30:00	QQQ	ETF	143.89	143.89	143.89	143.89	100.0
2017-08-03 06:00:00	QQQ	ETF	143.99	143.99	143.96	143.96	3500.0
2017-08-03 06:30:00	QQQ	ETF	143.98	144.18	143.98	144.17	3200.0
2017-08-03 07:00:00	QQQ	ETF	144.05	144.08	144.03	144.03	975.0
2017-08-03 07:30:00	QQQ	ETF	144.03	144.05	144.03	144.05	1500.0
2017-08-03 08:00:00	QQQ	ETF	144.19	144.19	144.07	144.15	15633.0
2017-08-03 08:30:00	QQQ	ETF	144.11	144.25	144.07	144.22	20140.0
2017-08-03 09:00:00	QQQ	ETF	144.22	144.23	144.07	144.15	120793.0
2017-08-03 09:30:00	QQQ	ETF	144.17	144.17	143.395	143.53	3341143.0
2017-08-03 10:00:00	QQQ	ETF	143.52	143.64	143.13	143.55	3417208.0
2017-08-03 10:30:00	QQQ	ETF	143.56	143.78	143.49	143.75	1509506.0
2017-08-03 11:00:00	QQQ	ETF	143.74	143.88	143.565	143.64	1341432.0
2017-08-03 11:30:00	QQQ	ETF	143.65	143.65	143.46	143.49	507753.0
2017-08-03 12:00:00	QQQ	ETF	143.49	143.72	143.42	143.7	561387.0
2017-08-03 12:30:00	QQQ	ETF	143.71	143.75	143.56	143.6	998896.0
2017-08-03 13:00:00	QQQ	ETF	143.6	143.6	143.31	143.3799	894655.0

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

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