PREVIEW / etf_30min / 2016-06-14

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-06-14.parquet
  size:    399 KB
  rows:    13,675

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
2016-06-14 04:00:00	SPY	ETF	208.1	208.12	207.84	207.85	9287.0
2016-06-14 04:30:00	SPY	ETF	207.84	207.86	207.54	207.76	12543.0
2016-06-14 05:00:00	SPY	ETF	207.74	207.88	207.64	207.64	6157.0
2016-06-14 05:30:00	SPY	ETF	207.66	207.88	207.66	207.87	29846.0
2016-06-14 06:00:00	SPY	ETF	207.89	207.95	207.87	207.95	12391.0
2016-06-14 06:30:00	SPY	ETF	207.94	208.18	207.94	207.99	63914.0
2016-06-14 07:00:00	SPY	ETF	208.0	208.08	207.87	208.08	550905.0
2016-06-14 07:30:00	SPY	ETF	208.08	208.08	207.76	207.8	339068.0
2016-06-14 08:00:00	SPY	ETF	207.81	208.536	207.66	207.68	465374.0
2016-06-14 08:30:00	SPY	ETF	207.68	208.02	207.66	207.97	678037.0
2016-06-14 09:00:00	SPY	ETF	207.97	208.03	207.74	208.01	941815.0
2016-06-14 09:30:00	SPY	ETF	208.0	208.74	207.94	208.4299	12570638.0
2016-06-14 10:00:00	SPY	ETF	208.42	208.64	207.52	207.73	11280260.0
2016-06-14 10:30:00	SPY	ETF	207.73	207.93	207.07	207.16	9658496.0
2016-06-14 11:00:00	SPY	ETF	207.17	207.4	206.94	207.09	9470394.0
2016-06-14 11:30:00	SPY	ETF	207.09	207.58	207.01	207.205	7965140.0
2016-06-14 12:00:00	SPY	ETF	207.2	208.04	207.14	207.95	9118837.0
2016-06-14 12:30:00	SPY	ETF	207.96	207.98	207.52	207.62	4482476.0
2016-06-14 13:00:00	SPY	ETF	207.61	207.72	207.31	207.345	6815552.0
2016-06-14 13:30:00	SPY	ETF	207.34	207.62	207.19	207.21	3861861.0
2016-06-14 14:00:00	SPY	ETF	207.22	207.74	207.18	207.71	4662237.0
2016-06-14 14:30:00	SPY	ETF	207.71	207.735	207.02	207.09	5351902.0
2016-06-14 15:00:00	SPY	ETF	207.1	208.0	206.9199	207.9801	11919022.0
2016-06-14 15:30:00	SPY	ETF	207.98	208.21	207.765	208.08	14737036.0
2016-06-14 16:00:00	SPY	ETF	208.08	208.16	207.57	207.98	8306094.0
2016-06-14 16:30:00	SPY	ETF	207.98	208.09	207.71	207.91	294020.0
2016-06-14 17:00:00	SPY	ETF	207.85	207.88	207.81	207.81	47781.0
2016-06-14 17:30:00	SPY	ETF	207.8	207.96	207.8	207.92	96082.0
2016-06-14 18:00:00	SPY	ETF	207.93	207.96	207.67	207.68	80553.0
2016-06-14 18:30:00	SPY	ETF	207.7	207.7	207.42	207.59	82957.0
2016-06-14 19:00:00	SPY	ETF	207.57	207.6	207.48	207.58	21690.0
2016-06-14 19:30:00	SPY	ETF	207.61	207.69	207.58	207.69	41142.0
2016-06-14 04:30:00	QQQ	ETF	107.66	107.66	107.58	107.58	1950.0
2016-06-14 05:00:00	QQQ	ETF	107.62	107.62	107.62	107.62	300.0
2016-06-14 05:30:00	QQQ	ETF	107.68	107.68	107.68	107.68	500.0
2016-06-14 06:00:00	QQQ	ETF	107.74	107.74	107.74	107.74	298.0
2016-06-14 06:30:00	QQQ	ETF	107.81	107.81	107.8	107.8	3900.0
2016-06-14 07:00:00	QQQ	ETF	107.8	107.83	107.74	107.83	5850.0
2016-06-14 07:30:00	QQQ	ETF	107.8	107.8	107.7	107.72	49698.0
2016-06-14 08:00:00	QQQ	ETF	107.74	107.76	107.63	107.63	47477.0
2016-06-14 08:30:00	QQQ	ETF	107.68	107.79	107.66	107.79	38136.0
2016-06-14 09:00:00	QQQ	ETF	107.74	107.79	107.67	107.79	411625.0
2016-06-14 09:30:00	QQQ	ETF	107.78	108.39	107.74	108.28	3654286.0
2016-06-14 10:00:00	QQQ	ETF	108.27	108.415	107.69	107.81	2334130.0
2016-06-14 10:30:00	QQQ	ETF	107.81	107.91	107.36	107.42	1783759.0
2016-06-14 11:00:00	QQQ	ETF	107.43	107.55	107.24	107.27	1871291.0
2016-06-14 11:30:00	QQQ	ETF	107.28	107.57	107.24	107.42	1996499.0
2016-06-14 12:00:00	QQQ	ETF	107.41	107.9	107.38	107.87	1615400.0
2016-06-14 12:30:00	QQQ	ETF	107.87	107.87	107.66	107.72	800016.0
2016-06-14 13:00:00	QQQ	ETF	107.72	107.78	107.59	107.62	593377.0

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

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