PREVIEW / etf_30min / 2013-12-31

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-12-31.parquet
  size:    338 KB
  rows:    11,606

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
2013-12-31 04:30:00	SPY	ETF	183.81	183.82	183.81	183.82	1000.0
2013-12-31 05:00:00	SPY	ETF	183.82	183.82	183.82	183.82	160.0
2013-12-31 06:30:00	SPY	ETF	183.84	183.84	183.84	183.84	400.0
2013-12-31 07:00:00	SPY	ETF	183.81	183.82	183.76	183.82	2638.0
2013-12-31 07:30:00	SPY	ETF	183.82	183.97	183.82	183.97	81640.0
2013-12-31 08:00:00	SPY	ETF	183.95	184.09	183.94	184.07	333718.0
2013-12-31 08:30:00	SPY	ETF	184.07	184.13	184.03	184.07	153206.0
2013-12-31 09:00:00	SPY	ETF	184.07	184.12	184.04	184.07	322569.0
2013-12-31 09:30:00	SPY	ETF	184.07	184.18	183.97	184.125	5483659.0
2013-12-31 10:00:00	SPY	ETF	184.13	184.31	184.125	184.22	5844145.0
2013-12-31 10:30:00	SPY	ETF	184.215	184.34	184.215	184.34	2608880.0
2013-12-31 11:00:00	SPY	ETF	184.34	184.6	184.33	184.49	4890677.0
2013-12-31 11:30:00	SPY	ETF	184.49	184.52	184.38	184.42	3557665.0
2013-12-31 12:00:00	SPY	ETF	184.42	184.45	184.34	184.38	2947814.0
2013-12-31 12:30:00	SPY	ETF	184.38	184.47	184.27	184.38	2786386.0
2013-12-31 13:00:00	SPY	ETF	184.38	184.39	184.25	184.38	1929804.0
2013-12-31 13:30:00	SPY	ETF	184.38	184.41	184.32	184.35	2066490.0
2013-12-31 14:00:00	SPY	ETF	184.36	184.38	184.121	184.17	4013683.0
2013-12-31 14:30:00	SPY	ETF	184.18	184.21	183.95	184.075	5206834.0
2013-12-31 15:00:00	SPY	ETF	184.08	184.17	183.93	184.13	5873522.0
2013-12-31 15:30:00	SPY	ETF	184.13	184.68	184.125	184.56	22204714.0
2013-12-31 16:00:00	SPY	ETF	184.55	184.89	184.51	184.85	7615803.0
2013-12-31 16:30:00	SPY	ETF	184.84	184.88	184.5412	184.84	4542647.0
2013-12-31 17:00:00	SPY	ETF	184.83	184.94	184.67	184.94	599337.0
2013-12-31 17:30:00	SPY	ETF	184.93	184.97	184.82	184.89	77831.0
2013-12-31 18:00:00	SPY	ETF	184.9	184.94	184.89	184.94	11400.0
2013-12-31 18:30:00	SPY	ETF	184.89	184.93	184.89	184.9	4800.0
2013-12-31 19:00:00	SPY	ETF	184.91	184.97	184.91	184.95	39816.0
2013-12-31 19:30:00	SPY	ETF	184.96	184.98	184.94	184.98	19530.0
2013-12-31 05:00:00	QQQ	ETF	87.41	87.41	87.41	87.41	400.0
2013-12-31 07:00:00	QQQ	ETF	87.43	87.43	87.43	87.43	1000.0
2013-12-31 07:30:00	QQQ	ETF	87.46	87.51	87.46	87.5	6920.0
2013-12-31 08:00:00	QQQ	ETF	87.5	87.51	87.5	87.5	10650.0
2013-12-31 08:30:00	QQQ	ETF	87.52	87.555	87.52	87.53	14026.0
2013-12-31 09:00:00	QQQ	ETF	87.53	87.56	87.52	87.54	31209.0
2013-12-31 09:30:00	QQQ	ETF	87.54	87.67	87.52	87.65	1836153.0
2013-12-31 10:00:00	QQQ	ETF	87.65	87.695	87.56	87.68	1204029.0
2013-12-31 10:30:00	QQQ	ETF	87.68	87.81	87.67	87.81	856272.0
2013-12-31 11:00:00	QQQ	ETF	87.809	87.93	87.78	87.82	2037576.0
2013-12-31 11:30:00	QQQ	ETF	87.82	87.84	87.795	87.805	1442788.0
2013-12-31 12:00:00	QQQ	ETF	87.82	87.83	87.76	87.8	1289288.0
2013-12-31 12:30:00	QQQ	ETF	87.8	87.84	87.7699	87.8129	928935.0
2013-12-31 13:00:00	QQQ	ETF	87.82	87.84	87.75	87.84	1100209.0
2013-12-31 13:30:00	QQQ	ETF	87.84	87.84	87.79	87.8	472684.0
2013-12-31 14:00:00	QQQ	ETF	87.81	87.83	87.73	87.75	1103926.0
2013-12-31 14:30:00	QQQ	ETF	87.75	87.77	87.65	87.7001	1224038.0
2013-12-31 15:00:00	QQQ	ETF	87.71	87.75	87.64	87.73	688712.0
2013-12-31 15:30:00	QQQ	ETF	87.73	87.96	87.73	87.95	4632642.0
2013-12-31 16:00:00	QQQ	ETF	87.96	88.11	87.564	88.081	1668594.0
2013-12-31 16:30:00	QQQ	ETF	88.08	88.09	88.04	88.04	111000.0

> showing 50 of 11,606 rows — these rows as CSV

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