PREVIEW / etf_30min / 2012-05-21

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-21.parquet
  size:    293 KB
  rows:    9,817

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-21 04:00:00	SPY	ETF	130.6	130.82	130.6	130.81	52038.0
2012-05-21 04:30:00	SPY	ETF	130.72	130.72	130.58	130.58	1100.0
2012-05-21 05:00:00	SPY	ETF	130.58	130.64	130.49	130.55	1300.0
2012-05-21 05:30:00	SPY	ETF	130.6	130.67	130.34	130.44	14000.0
2012-05-21 06:00:00	SPY	ETF	130.42	130.47	130.37	130.45	33882.0
2012-05-21 06:30:00	SPY	ETF	130.42	130.69	130.41	130.62	136804.0
2012-05-21 07:00:00	SPY	ETF	130.62	130.69	130.45	130.52	383900.0
2012-05-21 07:30:00	SPY	ETF	130.52	130.56	130.34	130.41	234797.0
2012-05-21 08:00:00	SPY	ETF	130.39	130.48	130.17	130.33	1047167.0
2012-05-21 08:30:00	SPY	ETF	130.33	130.41	130.08	130.16	1103031.0
2012-05-21 09:00:00	SPY	ETF	130.17	130.28	129.99	130.15	1309533.0
2012-05-21 09:30:00	SPY	ETF	130.16	130.49	129.95	130.36	24731736.0
2012-05-21 10:00:00	SPY	ETF	130.35	130.98	130.23	130.93	19175307.0
2012-05-21 10:30:00	SPY	ETF	130.925	131.46	130.92	131.36	16432895.0
2012-05-21 11:00:00	SPY	ETF	131.35	131.37	131.05	131.13	12104718.0
2012-05-21 11:30:00	SPY	ETF	131.14	131.21	131.0	131.06	8865405.0
2012-05-21 12:00:00	SPY	ETF	131.05	131.56	131.0	131.535	8258351.0
2012-05-21 12:30:00	SPY	ETF	131.54	131.55	131.24	131.338	6719613.0
2012-05-21 13:00:00	SPY	ETF	131.34	131.52	131.28	131.41	5368787.0
2012-05-21 13:30:00	SPY	ETF	131.42	131.63	131.37	131.489	6245354.0
2012-05-21 14:00:00	SPY	ETF	131.485	131.65	131.25	131.36	6554018.0
2012-05-21 14:30:00	SPY	ETF	131.36	131.75	131.36	131.66	7555151.0
2012-05-21 15:00:00	SPY	ETF	131.66	131.98	131.645	131.8624	8954440.0
2012-05-21 15:30:00	SPY	ETF	131.86	132.02	131.73	131.95	17678388.0
2012-05-21 16:00:00	SPY	ETF	131.98	132.16	131.965	132.11	16249723.0
2012-05-21 16:30:00	SPY	ETF	132.11	132.11	131.94	132.02	1363334.0
2012-05-21 17:00:00	SPY	ETF	132.02	132.05	131.98	132.02	98652.0
2012-05-21 17:30:00	SPY	ETF	132.05	132.05	131.96	132.0	47829.0
2012-05-21 18:00:00	SPY	ETF	131.98	132.15	131.97	132.08	75534.0
2012-05-21 18:30:00	SPY	ETF	132.06	132.11	132.04	132.04	21394.0
2012-05-21 19:00:00	SPY	ETF	132.04	132.11	132.04	132.08	4095.0
2012-05-21 19:30:00	SPY	ETF	132.09	132.14	132.03	132.14	26295.0
2012-05-21 04:00:00	QQQ	ETF	61.01	61.21	61.01	61.21	3100.0
2012-05-21 04:30:00	QQQ	ETF	61.15	61.15	61.15	61.15	100.0
2012-05-21 06:00:00	QQQ	ETF	61.07	61.07	61.07	61.07	100.0
2012-05-21 06:30:00	QQQ	ETF	61.06	61.15	61.06	61.15	12913.0
2012-05-21 07:00:00	QQQ	ETF	61.16	61.18	61.07	61.11	60160.0
2012-05-21 07:30:00	QQQ	ETF	61.11	61.11	61.03	61.05	57235.0
2012-05-21 08:00:00	QQQ	ETF	61.06	61.06	60.81	61.01	3187477.0
2012-05-21 08:30:00	QQQ	ETF	61.02	61.07	60.88	60.91	397418.0
2012-05-21 09:00:00	QQQ	ETF	60.91	60.96	60.81	60.92	531244.0
2012-05-21 09:30:00	QQQ	ETF	60.92	61.2	60.85	61.11	7493461.0
2012-05-21 10:00:00	QQQ	ETF	61.1	61.52	61.05	61.4884	6977770.0
2012-05-21 10:30:00	QQQ	ETF	61.48	61.87	61.48	61.82	4941964.0
2012-05-21 11:00:00	QQQ	ETF	61.81	61.8399	61.63	61.73	2759886.0
2012-05-21 11:30:00	QQQ	ETF	61.74	61.84	61.68	61.78	1559886.0
2012-05-21 12:00:00	QQQ	ETF	61.78	62.28	61.73	62.28	4786345.0
2012-05-21 12:30:00	QQQ	ETF	62.28	62.32	62.13	62.2	2643008.0
2012-05-21 13:00:00	QQQ	ETF	62.2	62.24	62.1	62.16	1790156.0
2012-05-21 13:30:00	QQQ	ETF	62.1586	62.3	62.14	62.21	1291423.0

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

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