PREVIEW / etf_30min / 2017-07-03

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-03.parquet
  size:    271 KB
  rows:    9,233

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-07-03 04:00:00	SPY	ETF	242.46	242.76	242.4	242.58	73275.0
2017-07-03 04:30:00	SPY	ETF	242.6	242.72	242.58	242.67	30723.0
2017-07-03 05:00:00	SPY	ETF	242.52	242.61	242.47	242.58	10750.0
2017-07-03 05:30:00	SPY	ETF	242.67	242.67	242.48	242.48	7300.0
2017-07-03 06:00:00	SPY	ETF	242.51	242.59	242.49	242.5	6721.0
2017-07-03 06:30:00	SPY	ETF	242.55	242.57	242.49	242.54	11690.0
2017-07-03 07:00:00	SPY	ETF	242.54	242.61	242.51	242.59	47477.0
2017-07-03 07:30:00	SPY	ETF	242.58	242.69	242.57	242.64	60769.0
2017-07-03 08:00:00	SPY	ETF	242.64	242.67	242.51	242.61	112661.0
2017-07-03 08:30:00	SPY	ETF	242.61	242.85	241.8	242.85	169272.0
2017-07-03 09:00:00	SPY	ETF	242.86	242.99	242.81	242.91	534701.0
2017-07-03 09:30:00	SPY	ETF	242.88	243.18	242.88	243.05	5688123.0
2017-07-03 10:00:00	SPY	ETF	243.13	243.38	242.943	243.02	4118888.0
2017-07-03 10:30:00	SPY	ETF	243.01	243.33	243.01	243.2	3677231.0
2017-07-03 11:00:00	SPY	ETF	243.2	243.26	242.99	243.15	3848905.0
2017-07-03 11:30:00	SPY	ETF	243.15	243.23	243.045	243.12	2587454.0
2017-07-03 12:00:00	SPY	ETF	243.125	243.14	242.41	242.69	4458658.0
2017-07-03 12:30:00	SPY	ETF	242.69	242.825	242.29	242.32	7113116.0
2017-07-03 13:00:00	SPY	ETF	242.31	243.11	241.98	241.99	5170041.0
2017-07-03 13:30:00	SPY	ETF	241.99	243.29	241.78	241.82	304813.0
2017-07-03 14:00:00	SPY	ETF	241.82	242.21	241.75	241.83	162663.0
2017-07-03 14:30:00	SPY	ETF	241.85	242.35	241.84	241.9	40922.0
2017-07-03 15:00:00	SPY	ETF	241.89	241.9	241.76	241.8	81829.0
2017-07-03 15:30:00	SPY	ETF	241.83	241.88	241.83	241.83	11369.0
2017-07-03 16:00:00	SPY	ETF	241.83	241.86	241.8	241.83	7166.0
2017-07-03 16:30:00	SPY	ETF	241.83	241.86	241.82	241.83	3672.0
2017-07-03 04:00:00	QQQ	ETF	137.99	138.0	137.99	138.0	10870.0
2017-07-03 04:30:00	QQQ	ETF	138.03	138.03	137.95	137.95	1400.0
2017-07-03 05:00:00	QQQ	ETF	137.99	137.99	137.9	137.95	1686.0
2017-07-03 05:30:00	QQQ	ETF	137.97	137.97	137.9	137.9	1277.0
2017-07-03 06:00:00	QQQ	ETF	137.95	137.95	137.78	137.84	14056.0
2017-07-03 06:30:00	QQQ	ETF	137.78	137.84	137.78	137.84	1842.0
2017-07-03 07:00:00	QQQ	ETF	137.86	137.86	137.8	137.81	8145.0
2017-07-03 07:30:00	QQQ	ETF	137.86	137.98	137.83	137.98	10657.0
2017-07-03 08:00:00	QQQ	ETF	137.92	138.0	137.9	138.0	26308.0
2017-07-03 08:30:00	QQQ	ETF	137.99	138.27	137.64	138.27	88955.0
2017-07-03 09:00:00	QQQ	ETF	138.27	138.38	138.22	138.25	100274.0
2017-07-03 09:30:00	QQQ	ETF	138.25	138.43	137.8	137.93	3826412.0
2017-07-03 10:00:00	QQQ	ETF	137.94	138.1	137.3	137.46	3314498.0
2017-07-03 10:30:00	QQQ	ETF	137.46	137.57	136.91	136.93	2535905.0
2017-07-03 11:00:00	QQQ	ETF	136.92	136.99	136.42	136.9	3963223.0
2017-07-03 11:30:00	QQQ	ETF	136.91	136.96	136.62	136.885	2032638.0
2017-07-03 12:00:00	QQQ	ETF	136.88	136.88	136.281	136.5	2600272.0
2017-07-03 12:30:00	QQQ	ETF	136.5	136.5	136.1	136.18	5522414.0
2017-07-03 13:00:00	QQQ	ETF	136.18	136.24	135.8	135.97	1972759.0
2017-07-03 13:30:00	QQQ	ETF	135.97	137.9049	135.91	135.96	113711.0
2017-07-03 14:00:00	QQQ	ETF	135.95	136.2	135.93	136.05	615160.0
2017-07-03 14:30:00	QQQ	ETF	136.0	136.04	135.96	136.0	2529.0
2017-07-03 15:00:00	QQQ	ETF	136.0	136.08	135.95	136.02	4049.0
2017-07-03 15:30:00	QQQ	ETF	136.04	136.06	135.99	135.99	2836.0

> showing 50 of 9,233 rows — these rows as CSV

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