PREVIEW / etf_30min / 2012-05-24

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-24.parquet
  size:    285 KB
  rows:    9,551

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
2012-05-24 04:00:00	SPY	ETF	131.53	131.68	131.39	131.68	2700.0
2012-05-24 04:30:00	SPY	ETF	131.65	131.99	131.56	131.98	15500.0
2012-05-24 05:00:00	SPY	ETF	131.93	132.14	131.91	132.14	15430.0
2012-05-24 05:30:00	SPY	ETF	132.16	132.57	132.08	132.56	23431.0
2012-05-24 06:00:00	SPY	ETF	132.58	132.9	132.58	132.87	63491.0
2012-05-24 06:30:00	SPY	ETF	132.86	132.9	132.65	132.74	127117.0
2012-05-24 07:00:00	SPY	ETF	132.74	132.75	132.46	132.6	221488.0
2012-05-24 07:30:00	SPY	ETF	132.56	132.68	132.36	132.39	358715.0
2012-05-24 08:00:00	SPY	ETF	132.43	132.7	132.27	132.45	688478.0
2012-05-24 08:30:00	SPY	ETF	132.42	132.82	132.2	132.78	1625251.0
2012-05-24 09:00:00	SPY	ETF	132.78	132.9	131.36	132.64	2079698.0
2012-05-24 09:30:00	SPY	ETF	132.63	132.67	131.94	132.17	20804511.0
2012-05-24 10:00:00	SPY	ETF	132.16	132.44	131.99	132.39	15289954.0
2012-05-24 10:30:00	SPY	ETF	132.39	132.84	132.31	132.46	11805835.0
2012-05-24 11:00:00	SPY	ETF	132.47	132.83	132.36	132.5813	8860320.0
2012-05-24 11:30:00	SPY	ETF	132.58	132.59	132.1	132.19	8186737.0
2012-05-24 12:00:00	SPY	ETF	132.18	132.23	131.75	131.84	12106086.0
2012-05-24 12:30:00	SPY	ETF	131.8494	132.05	131.74	131.94	5443552.0
2012-05-24 13:00:00	SPY	ETF	131.94	132.19	131.8	131.82	7669862.0
2012-05-24 13:30:00	SPY	ETF	131.81	131.96	131.45	131.46	10519322.0
2012-05-24 14:00:00	SPY	ETF	131.46	131.78	131.42	131.77	10902535.0
2012-05-24 14:30:00	SPY	ETF	131.77	131.94	131.49	131.58	10017871.0
2012-05-24 15:00:00	SPY	ETF	131.58	132.27	131.53	132.14	11613439.0
2012-05-24 15:30:00	SPY	ETF	132.14	132.51	132.01	132.5	17416422.0
2012-05-24 16:00:00	SPY	ETF	132.5	132.92	132.2066	132.82	9975267.0
2012-05-24 16:30:00	SPY	ETF	132.82	133.03	132.76	132.94	801503.0
2012-05-24 17:00:00	SPY	ETF	132.96	132.96	132.86	132.89	103694.0
2012-05-24 17:30:00	SPY	ETF	132.91	132.93	132.81	132.88	71722.0
2012-05-24 18:00:00	SPY	ETF	132.87	132.87	132.78	132.8	80690.0
2012-05-24 18:30:00	SPY	ETF	132.8	132.85	132.71	132.71	116663.0
2012-05-24 19:00:00	SPY	ETF	132.71	132.71	132.63	132.65	66968.0
2012-05-24 19:30:00	SPY	ETF	132.68	132.76	132.67	132.76	75513.0
2012-05-24 04:00:00	QQQ	ETF	62.17	62.17	62.07	62.07	2012.0
2012-05-24 05:00:00	QQQ	ETF	62.4	62.42	62.4	62.42	2000.0
2012-05-24 05:30:00	QQQ	ETF	62.41	62.55	62.41	62.55	400.0
2012-05-24 06:00:00	QQQ	ETF	62.65	62.77	62.61	62.77	7500.0
2012-05-24 06:30:00	QQQ	ETF	62.75	62.75	62.75	62.75	800.0
2012-05-24 07:00:00	QQQ	ETF	62.71	62.71	62.58	62.66	28050.0
2012-05-24 07:30:00	QQQ	ETF	62.62	62.7	62.56	62.56	38600.0
2012-05-24 08:00:00	QQQ	ETF	62.55	62.58	62.49	62.56	75207.0
2012-05-24 08:30:00	QQQ	ETF	62.55	62.77	62.44	62.75	342483.0
2012-05-24 09:00:00	QQQ	ETF	62.75	62.8	62.6	62.66	287637.0
2012-05-24 09:30:00	QQQ	ETF	62.66	62.71	62.0899	62.1999	7138069.0
2012-05-24 10:00:00	QQQ	ETF	62.19	62.45	62.13	62.43	4635891.0
2012-05-24 10:30:00	QQQ	ETF	62.42	62.6201	62.36	62.41	3270175.0
2012-05-24 11:00:00	QQQ	ETF	62.42	62.6	62.37	62.47	2605144.0
2012-05-24 11:30:00	QQQ	ETF	62.47	62.4701	62.19	62.24	3351217.0
2012-05-24 12:00:00	QQQ	ETF	62.2491	62.258	62.025	62.11	2832979.0
2012-05-24 12:30:00	QQQ	ETF	62.1	62.22	62.0415	62.13	2050810.0
2012-05-24 13:00:00	QQQ	ETF	62.13	62.28	62.0	62.04	3295822.0

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

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