PREVIEW / etf_30min / 2017-06-12

all etf 30-min files

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

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-06-12 04:00:00	SPY	ETF	243.28	243.28	242.87	242.89	10313.0
2017-06-12 04:30:00	SPY	ETF	242.88	242.94	242.76	242.77	18047.0
2017-06-12 05:00:00	SPY	ETF	242.75	242.97	242.75	242.97	1314.0
2017-06-12 05:30:00	SPY	ETF	243.0	243.0	242.7	242.88	47156.0
2017-06-12 06:00:00	SPY	ETF	242.8	242.93	242.78	242.93	108315.0
2017-06-12 06:30:00	SPY	ETF	242.87	243.04	242.87	242.98	112134.0
2017-06-12 07:00:00	SPY	ETF	242.98	243.01	242.79	242.95	157166.0
2017-06-12 07:30:00	SPY	ETF	242.96	243.06	242.8	242.86	279998.0
2017-06-12 08:00:00	SPY	ETF	242.91	243.14	242.8	243.14	322496.0
2017-06-12 08:30:00	SPY	ETF	243.13	243.25	243.11	243.14	280558.0
2017-06-12 09:00:00	SPY	ETF	243.12	243.41	242.98	243.11	463569.0
2017-06-12 09:30:00	SPY	ETF	243.13	243.42	242.46	242.62	11784991.0
2017-06-12 10:00:00	SPY	ETF	242.62	243.01	242.38	242.81	9598660.0
2017-06-12 10:30:00	SPY	ETF	242.805	243.14	242.57	243.08	5463197.0
2017-06-12 11:00:00	SPY	ETF	243.075	243.25	242.99	243.06	5433479.0
2017-06-12 11:30:00	SPY	ETF	243.065	243.2	242.79	242.95	4711764.0
2017-06-12 12:00:00	SPY	ETF	242.95	243.0	242.63	242.68	3752293.0
2017-06-12 12:30:00	SPY	ETF	242.69	242.86	242.47	242.48	3434611.0
2017-06-12 13:00:00	SPY	ETF	242.48	242.86	242.45	242.85	3677220.0
2017-06-12 13:30:00	SPY	ETF	242.855	242.935	242.5	242.515	3405299.0
2017-06-12 14:00:00	SPY	ETF	242.5101	242.86	242.49	242.7	2224869.0
2017-06-12 14:30:00	SPY	ETF	242.7	243.06	242.63	242.965	4361150.0
2017-06-12 15:00:00	SPY	ETF	242.96	243.15	242.81	242.87	5782953.0
2017-06-12 15:30:00	SPY	ETF	242.87	243.39	242.81	243.34	9480284.0
2017-06-12 16:00:00	SPY	ETF	243.33	243.5718	242.9914	243.33	9621896.0
2017-06-12 16:30:00	SPY	ETF	243.33	243.43	243.25	243.38	199847.0
2017-06-12 17:00:00	SPY	ETF	243.37	243.42	242.8955	243.42	96554.0
2017-06-12 17:30:00	SPY	ETF	243.42	243.46	243.34	243.36	98390.0
2017-06-12 18:00:00	SPY	ETF	243.35	243.35	243.23	243.3	101950.0
2017-06-12 18:30:00	SPY	ETF	243.3	243.37	243.3	243.34	40803.0
2017-06-12 19:00:00	SPY	ETF	243.34	243.36	243.28	243.28	13213.0
2017-06-12 19:30:00	SPY	ETF	243.34	243.4	243.28	243.4	11647.0
2017-06-12 04:00:00	QQQ	ETF	139.28	139.28	138.66	138.71	28240.0
2017-06-12 04:30:00	QQQ	ETF	138.67	138.7	138.38	138.47	11042.0
2017-06-12 05:00:00	QQQ	ETF	138.45	138.91	138.45	138.9	14150.0
2017-06-12 05:30:00	QQQ	ETF	138.83	138.98	138.75	138.9	109280.0
2017-06-12 06:00:00	QQQ	ETF	138.92	139.07	138.92	139.05	17888.0
2017-06-12 06:30:00	QQQ	ETF	139.05	139.21	139.02	139.15	16271.0
2017-06-12 07:00:00	QQQ	ETF	139.13	139.17	138.76	138.86	109606.0
2017-06-12 07:30:00	QQQ	ETF	138.86	138.92	138.55	138.64	502694.0
2017-06-12 08:00:00	QQQ	ETF	138.8	139.14	138.5	138.83	539582.0
2017-06-12 08:30:00	QQQ	ETF	138.84	139.22	138.84	139.01	345841.0
2017-06-12 09:00:00	QQQ	ETF	139.0	139.06	138.81	138.84	928235.0
2017-06-12 09:30:00	QQQ	ETF	138.84	139.08	137.47	137.94	25310029.0
2017-06-12 10:00:00	QQQ	ETF	137.94	138.78	137.73	138.23	12285317.0
2017-06-12 10:30:00	QQQ	ETF	138.23	138.96	138.0901	138.76	7093064.0
2017-06-12 11:00:00	QQQ	ETF	138.76	139.48	138.65	139.25	5911256.0
2017-06-12 11:30:00	QQQ	ETF	139.25	139.4289	138.71	138.92	4301955.0
2017-06-12 12:00:00	QQQ	ETF	138.92	139.0152	138.43	138.54	3082438.0
2017-06-12 12:30:00	QQQ	ETF	138.545	138.75	138.35	138.4	2379835.0

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

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