PREVIEW / etf_30min / 2011-10-17

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-17.parquet
  size:    284 KB
  rows:    9,433

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-10-17 04:00:00	SPY	ETF	123.01	123.59	123.01	123.55	16129.0
2011-10-17 04:30:00	SPY	ETF	123.48	123.6	123.4	123.41	41580.0
2011-10-17 05:00:00	SPY	ETF	123.49	123.5	123.06	123.06	34035.0
2011-10-17 05:30:00	SPY	ETF	122.99	123.1	122.93	122.98	30800.0
2011-10-17 06:00:00	SPY	ETF	122.98	123.06	122.88	122.98	22222.0
2011-10-17 06:30:00	SPY	ETF	123.0	123.0	122.58	122.59	73525.0
2011-10-17 07:00:00	SPY	ETF	122.58	122.63	122.22	122.43	1094374.0
2011-10-17 07:30:00	SPY	ETF	122.4	122.55	122.16	122.32	842806.0
2011-10-17 08:00:00	SPY	ETF	122.32	123.5	122.15	122.47	2938787.0
2011-10-17 08:30:00	SPY	ETF	122.46	122.46	122.0	122.09	1703952.0
2011-10-17 09:00:00	SPY	ETF	122.08	122.11	121.81	122.0	1890504.0
2011-10-17 09:30:00	SPY	ETF	121.99	122.06	121.5	121.57	21573551.0
2011-10-17 10:00:00	SPY	ETF	121.58	121.6142	121.1	121.11	17207633.0
2011-10-17 10:30:00	SPY	ETF	121.11	121.35	120.87	121.21	17005612.0
2011-10-17 11:00:00	SPY	ETF	121.2	121.39	121.11	121.37	8414033.0
2011-10-17 11:30:00	SPY	ETF	121.36	121.43	120.96	121.0	8154278.0
2011-10-17 12:00:00	SPY	ETF	121.0	121.07	120.75	120.996	7411834.0
2011-10-17 12:30:00	SPY	ETF	120.99	121.0	120.55	120.63	8320288.0
2011-10-17 13:00:00	SPY	ETF	120.63	120.92	120.5	120.76	8511745.0
2011-10-17 13:30:00	SPY	ETF	120.75	120.76	120.33	120.61	10033685.0
2011-10-17 14:00:00	SPY	ETF	120.6	120.7	120.27	120.4	8780720.0
2011-10-17 14:30:00	SPY	ETF	120.39	122.5492	120.03	120.43	13039289.0
2011-10-17 15:00:00	SPY	ETF	120.43	120.759	120.35	120.5	14104715.0
2011-10-17 15:30:00	SPY	ETF	120.5	120.74	119.93	120.21	28435565.0
2011-10-17 16:00:00	SPY	ETF	120.22	121.9	119.9	120.02	17255797.0
2011-10-17 16:30:00	SPY	ETF	120.01	120.24	119.66	119.77	3079131.0
2011-10-17 17:00:00	SPY	ETF	119.79	119.81	119.29	119.53	550467.0
2011-10-17 17:30:00	SPY	ETF	119.53	119.77	119.53	119.66	94440.0
2011-10-17 18:00:00	SPY	ETF	119.65	120.24	119.55	119.71	381509.0
2011-10-17 18:30:00	SPY	ETF	119.73	119.8	119.65	119.8	14298.0
2011-10-17 19:00:00	SPY	ETF	119.82	119.96	119.8	119.88	34911.0
2011-10-17 19:30:00	SPY	ETF	119.86	119.92	119.69	119.69	191045.0
2011-10-17 04:00:00	QQQ	ETF	58.56	58.72	58.56	58.72	1111.0
2011-10-17 05:30:00	QQQ	ETF	58.54	58.54	58.4	58.4	4400.0
2011-10-17 06:00:00	QQQ	ETF	58.4	58.5	58.39	58.5	7550.0
2011-10-17 06:30:00	QQQ	ETF	58.32	58.33	58.25	58.25	12400.0
2011-10-17 07:00:00	QQQ	ETF	58.22	58.23	58.06	58.08	370229.0
2011-10-17 07:30:00	QQQ	ETF	58.1	58.19	58.0	58.04	524459.0
2011-10-17 08:00:00	QQQ	ETF	58.04	58.22	57.94	58.02	2368825.0
2011-10-17 08:30:00	QQQ	ETF	58.02	58.03	57.8	57.85	1298424.0
2011-10-17 09:00:00	QQQ	ETF	57.85	57.91	57.75	57.9	3633812.0
2011-10-17 09:30:00	QQQ	ETF	57.9	58.09	57.83	57.87	7177128.0
2011-10-17 10:00:00	QQQ	ETF	57.87	57.9106	57.68	57.68	4824770.0
2011-10-17 10:30:00	QQQ	ETF	57.68	57.86	57.64	57.689	3384197.0
2011-10-17 11:00:00	QQQ	ETF	57.68	57.846	57.66	57.83	3076947.0
2011-10-17 11:30:00	QQQ	ETF	57.83	57.87	57.55	57.5571	1945908.0
2011-10-17 12:00:00	QQQ	ETF	57.55	57.55	57.4	57.49	2163056.0
2011-10-17 12:30:00	QQQ	ETF	57.49	57.5	57.2199	57.3	3812244.0
2011-10-17 13:00:00	QQQ	ETF	57.2958	57.47	57.21	57.36	2093983.0
2011-10-17 13:30:00	QQQ	ETF	57.37	57.39	57.17	57.3001	2503590.0

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

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