PREVIEW / etf_30min / 2015-07-06

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-07-06.parquet
  size:    397 KB
  rows:    13,398

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
2015-07-06 04:00:00	SPY	ETF	206.26	206.26	205.81	205.85	9008.0
2015-07-06 04:30:00	SPY	ETF	205.91	206.06	205.77	206.0	18272.0
2015-07-06 05:00:00	SPY	ETF	205.97	206.19	205.87	206.19	29656.0
2015-07-06 05:30:00	SPY	ETF	206.13	206.5	206.13	206.43	32563.0
2015-07-06 06:00:00	SPY	ETF	206.46	206.51	206.2	206.27	29982.0
2015-07-06 06:30:00	SPY	ETF	206.31	206.31	206.13	206.18	42165.0
2015-07-06 07:00:00	SPY	ETF	206.2	206.35	206.0	206.07	236147.0
2015-07-06 07:30:00	SPY	ETF	206.05	206.12	205.48	205.57	378188.0
2015-07-06 08:00:00	SPY	ETF	205.57	206.22	205.54	205.84	527431.0
2015-07-06 08:30:00	SPY	ETF	205.88	205.92	204.5228	205.75	648870.0
2015-07-06 09:00:00	SPY	ETF	205.76	205.97	205.67	205.76	432250.0
2015-07-06 09:30:00	SPY	ETF	205.77	206.59	205.53	206.39	14057962.0
2015-07-06 10:00:00	SPY	ETF	206.38	206.86	206.24	206.76	8621618.0
2015-07-06 10:30:00	SPY	ETF	206.7625	207.65	206.735	207.1956	12267570.0
2015-07-06 11:00:00	SPY	ETF	207.2	207.28	206.71	206.75	7528533.0
2015-07-06 11:30:00	SPY	ETF	206.75	207.4303	206.64	206.95	4460494.0
2015-07-06 12:00:00	SPY	ETF	206.95	207.09	206.761	206.975	2606156.0
2015-07-06 12:30:00	SPY	ETF	206.98	206.98	206.67	206.8	2819640.0
2015-07-06 13:00:00	SPY	ETF	206.79	206.91	206.26	206.29	4873631.0
2015-07-06 13:30:00	SPY	ETF	206.29	206.295	205.98	206.0657	11037488.0
2015-07-06 14:00:00	SPY	ETF	206.06	206.19	205.77	205.78	7626190.0
2015-07-06 14:30:00	SPY	ETF	205.78	206.06	205.68	205.9	6203798.0
2015-07-06 15:00:00	SPY	ETF	205.9	206.28	205.84	206.15	7791228.0
2015-07-06 15:30:00	SPY	ETF	206.15	206.72	206.13	206.7	12798827.0
2015-07-06 16:00:00	SPY	ETF	206.71	207.09	206.474	207.05	3598995.0
2015-07-06 16:30:00	SPY	ETF	207.06	207.35	207.06	207.29	2760465.0
2015-07-06 17:00:00	SPY	ETF	207.29	207.51	207.29	207.46	478210.0
2015-07-06 17:30:00	SPY	ETF	207.46	207.49	207.41	207.41	76196.0
2015-07-06 18:00:00	SPY	ETF	207.44	207.52	207.44	207.47	67551.0
2015-07-06 18:30:00	SPY	ETF	207.47	207.86	207.45	207.7	108879.0
2015-07-06 19:00:00	SPY	ETF	207.69	207.7	207.58	207.58	36816.0
2015-07-06 19:30:00	SPY	ETF	207.58	207.6	207.46	207.52	135243.0
2015-07-06 04:00:00	QQQ	ETF	107.14	107.2	107.1	107.15	1900.0
2015-07-06 04:30:00	QQQ	ETF	107.2	107.2	107.2	107.2	250.0
2015-07-06 06:00:00	QQQ	ETF	107.44	107.44	107.44	107.44	1000.0
2015-07-06 06:30:00	QQQ	ETF	107.27	107.27	107.27	107.27	1000.0
2015-07-06 07:00:00	QQQ	ETF	107.3	107.34	107.2	107.24	12920.0
2015-07-06 07:30:00	QQQ	ETF	107.25	107.27	107.04	107.05	31814.0
2015-07-06 08:00:00	QQQ	ETF	107.11	107.33	107.09	107.31	60604.0
2015-07-06 08:30:00	QQQ	ETF	107.32	107.32	107.15	107.23	78592.0
2015-07-06 09:00:00	QQQ	ETF	107.26	107.31	107.21	107.28	218944.0
2015-07-06 09:30:00	QQQ	ETF	107.27	107.7	107.04	107.6161	4299422.0
2015-07-06 10:00:00	QQQ	ETF	107.61	107.87	107.4838	107.77	1909172.0
2015-07-06 10:30:00	QQQ	ETF	107.77	108.32	107.73	108.03	2139752.0
2015-07-06 11:00:00	QQQ	ETF	108.04	108.09	107.7001	107.73	1435074.0
2015-07-06 11:30:00	QQQ	ETF	107.73	107.83	107.65	107.8	1022524.0
2015-07-06 12:00:00	QQQ	ETF	107.8	107.89	107.69	107.79	704477.0
2015-07-06 12:30:00	QQQ	ETF	107.8	107.8075	107.66	107.77	593743.0
2015-07-06 13:00:00	QQQ	ETF	107.77	107.81	107.475	107.49	1329354.0
2015-07-06 13:30:00	QQQ	ETF	107.49	107.49	107.3	107.36	1214897.0

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

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