PREVIEW / etf_30min / 2011-01-05

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-05.parquet
  size:    283 KB
  rows:    9,424

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
2011-01-05 04:00:00	SPY	ETF	126.64	126.64	126.2	126.41	7504.0
2011-01-05 04:30:00	SPY	ETF	126.33	126.33	126.25	126.25	300.0
2011-01-05 05:00:00	SPY	ETF	126.24	126.24	126.2	126.2	500.0
2011-01-05 05:30:00	SPY	ETF	126.24	126.24	126.11	126.11	700.0
2011-01-05 06:00:00	SPY	ETF	126.1	126.18	126.08	126.11	22500.0
2011-01-05 06:30:00	SPY	ETF	126.09	126.11	125.95	126.09	35550.0
2011-01-05 07:00:00	SPY	ETF	126.06	126.2	126.04	126.09	160825.0
2011-01-05 07:30:00	SPY	ETF	126.09	126.15	126.03	126.13	536755.0
2011-01-05 08:00:00	SPY	ETF	126.16	126.8	126.06	126.45	2906448.0
2011-01-05 08:30:00	SPY	ETF	126.45	126.62	126.34	126.59	1304494.0
2011-01-05 09:00:00	SPY	ETF	126.59	126.93	126.45	126.57	1820876.0
2011-01-05 09:30:00	SPY	ETF	126.58	126.82	126.46	126.73	16251131.0
2011-01-05 10:00:00	SPY	ETF	126.73	127.04	126.6742	126.86	12334134.0
2011-01-05 10:30:00	SPY	ETF	126.86	127.08	126.75	126.96	8499526.0
2011-01-05 11:00:00	SPY	ETF	126.96	127.36	126.89	127.33	12916716.0
2011-01-05 11:30:00	SPY	ETF	127.33	127.51	127.33	127.4099	6748759.0
2011-01-05 12:00:00	SPY	ETF	127.4001	127.57	127.375	127.555	7258360.0
2011-01-05 12:30:00	SPY	ETF	127.5522	127.65	127.52	127.54	5074603.0
2011-01-05 13:00:00	SPY	ETF	127.54	127.58	127.41	127.52	7427889.0
2011-01-05 13:30:00	SPY	ETF	127.52	127.645	127.47	127.6	5179148.0
2011-01-05 14:00:00	SPY	ETF	127.61	127.67	127.47	127.49	4582722.0
2011-01-05 14:30:00	SPY	ETF	127.495	127.58	127.42	127.58	5069687.0
2011-01-05 15:00:00	SPY	ETF	127.58	127.725	127.57	127.57	7457967.0
2011-01-05 15:30:00	SPY	ETF	127.57	127.67	127.5	127.63	13808905.0
2011-01-05 16:00:00	SPY	ETF	127.62	127.72	126.555	127.51	11836073.0
2011-01-05 16:30:00	SPY	ETF	127.54	127.54	127.47	127.48	364142.0
2011-01-05 17:00:00	SPY	ETF	127.48	127.53	127.46	127.46	88712.0
2011-01-05 17:30:00	SPY	ETF	127.47	127.51	127.41	127.48	39452.0
2011-01-05 18:00:00	SPY	ETF	127.48	127.64	127.48	127.55	38322.0
2011-01-05 18:30:00	SPY	ETF	127.56	127.57	127.55	127.55	9070.0
2011-01-05 19:00:00	SPY	ETF	127.57	127.57	127.54	127.55	6700.0
2011-01-05 19:30:00	SPY	ETF	127.54	127.58	127.48	127.48	60754.0
2011-01-05 04:00:00	QQQ	ETF	55.01	55.01	54.85	54.85	4000.0
2011-01-05 04:30:00	QQQ	ETF	54.89	54.89	54.89	54.89	500.0
2011-01-05 05:00:00	QQQ	ETF	54.86	54.86	54.86	54.86	500.0
2011-01-05 05:30:00	QQQ	ETF	54.86	54.86	54.85	54.85	5100.0
2011-01-05 06:00:00	QQQ	ETF	54.85	54.86	54.82	54.84	2200.0
2011-01-05 06:30:00	QQQ	ETF	54.82	54.82	54.77	54.8	21100.0
2011-01-05 07:00:00	QQQ	ETF	54.81	54.86	54.81	54.83	73983.0
2011-01-05 07:30:00	QQQ	ETF	54.84	54.84	54.8	54.83	62186.0
2011-01-05 08:00:00	QQQ	ETF	54.84	55.11	54.82	55.0	857535.0
2011-01-05 08:30:00	QQQ	ETF	55.0	55.08	54.94	55.07	376822.0
2011-01-05 09:00:00	QQQ	ETF	55.07	55.12	55.06	55.1	377266.0
2011-01-05 09:30:00	QQQ	ETF	55.11	55.24	55.07	55.21	5359623.0
2011-01-05 10:00:00	QQQ	ETF	55.22	55.43	55.21	55.35	5353606.0
2011-01-05 10:30:00	QQQ	ETF	55.34	55.49	55.32	55.45	3231389.0
2011-01-05 11:00:00	QQQ	ETF	55.46	55.64	55.44	55.63	2926316.0
2011-01-05 11:30:00	QQQ	ETF	55.63	55.69	55.57	55.59	2535520.0
2011-01-05 12:00:00	QQQ	ETF	55.59	55.69	55.57	55.679	2341771.0
2011-01-05 12:30:00	QQQ	ETF	55.6799	55.73	55.64	55.67	1965278.0

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

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