PREVIEW / etf_30min / 2013-04-19

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-19.parquet
  size:    302 KB
  rows:    10,275

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-04-19 04:00:00	SPY	ETF	154.75	154.75	154.71	154.75	13500.0
2013-04-19 04:30:00	SPY	ETF	154.75	154.94	154.75	154.94	14675.0
2013-04-19 05:00:00	SPY	ETF	154.85	154.9	154.74	154.83	17900.0
2013-04-19 05:30:00	SPY	ETF	154.91	154.99	154.91	154.92	4000.0
2013-04-19 06:00:00	SPY	ETF	154.89	155.03	154.86	154.92	20300.0
2013-04-19 06:30:00	SPY	ETF	154.92	155.03	154.9	154.92	61000.0
2013-04-19 07:00:00	SPY	ETF	154.92	154.95	154.78	154.8	273927.0
2013-04-19 07:30:00	SPY	ETF	154.79	154.91	154.68	154.8	171459.0
2013-04-19 08:00:00	SPY	ETF	154.79	154.92	154.57	154.69	1914264.0
2013-04-19 08:30:00	SPY	ETF	154.69	154.72	154.36	154.54	877243.0
2013-04-19 09:00:00	SPY	ETF	154.51	154.635	154.35	154.5	2654479.0
2013-04-19 09:30:00	SPY	ETF	154.5	154.75	154.12	154.45	24938502.0
2013-04-19 10:00:00	SPY	ETF	154.45	154.94	154.43	154.64	16549046.0
2013-04-19 10:30:00	SPY	ETF	154.64	154.93	154.58	154.86	10008898.0
2013-04-19 11:00:00	SPY	ETF	154.87	155.36	154.78	155.19	11586257.0
2013-04-19 11:30:00	SPY	ETF	155.19	155.46	155.19	155.309	6276798.0
2013-04-19 12:00:00	SPY	ETF	155.3	155.39	155.08	155.14	8081635.0
2013-04-19 12:30:00	SPY	ETF	155.14	155.22	154.92	155.01	4504204.0
2013-04-19 13:00:00	SPY	ETF	155.0	155.23	154.881	155.23	4503740.0
2013-04-19 13:30:00	SPY	ETF	155.22	155.225	155.065	155.1	3807031.0
2013-04-19 14:00:00	SPY	ETF	155.11	155.37	155.08	155.28	4570933.0
2013-04-19 14:30:00	SPY	ETF	155.28	155.4	155.04	155.12	5048418.0
2013-04-19 15:00:00	SPY	ETF	155.13	155.37	154.99	155.35	6678411.0
2013-04-19 15:30:00	SPY	ETF	155.36	155.55	155.31	155.45	17189052.0
2013-04-19 16:00:00	SPY	ETF	155.41	155.49	154.7499	155.22	11837703.0
2013-04-19 16:30:00	SPY	ETF	155.22	155.4845	155.2	155.31	2495140.0
2013-04-19 17:00:00	SPY	ETF	155.31	155.32	155.27	155.3	997269.0
2013-04-19 17:30:00	SPY	ETF	155.3	155.4	155.29	155.34	116716.0
2013-04-19 18:00:00	SPY	ETF	155.33	155.33	155.2	155.23	69369.0
2013-04-19 18:30:00	SPY	ETF	155.26	155.29	155.25	155.29	6790.0
2013-04-19 19:00:00	SPY	ETF	155.3	155.31	155.25	155.25	5958.0
2013-04-19 19:30:00	SPY	ETF	155.23	155.28	155.18	155.19	28098.0
2013-04-19 04:00:00	QQQ	ETF	67.63	67.65	67.63	67.65	300.0
2013-04-19 04:30:00	QQQ	ETF	67.7	67.7	67.7	67.7	4000.0
2013-04-19 05:00:00	QQQ	ETF	67.65	67.65	67.59	67.63	9998.0
2013-04-19 05:30:00	QQQ	ETF	67.67	67.71	67.67	67.7	17000.0
2013-04-19 06:00:00	QQQ	ETF	67.67	67.67	67.65	67.65	25000.0
2013-04-19 06:30:00	QQQ	ETF	67.7	67.7	67.7	67.7	35100.0
2013-04-19 07:00:00	QQQ	ETF	67.7	67.7	67.65	67.66	138910.0
2013-04-19 07:30:00	QQQ	ETF	67.62	67.7	67.62	67.65	23700.0
2013-04-19 08:00:00	QQQ	ETF	67.64	67.76	67.58	67.73	1286465.0
2013-04-19 08:30:00	QQQ	ETF	67.61	67.61	67.5	67.55	91129.0
2013-04-19 09:00:00	QQQ	ETF	67.54	67.62	67.32	67.32	1880003.0
2013-04-19 09:30:00	QQQ	ETF	67.31	67.6001	67.2	67.59	6743993.0
2013-04-19 10:00:00	QQQ	ETF	67.59	67.89	67.58	67.73	4966429.0
2013-04-19 10:30:00	QQQ	ETF	67.7299	67.9399	67.7	67.91	2547165.0
2013-04-19 11:00:00	QQQ	ETF	67.91	68.21	67.86	68.1	2776330.0
2013-04-19 11:30:00	QQQ	ETF	68.1	68.231	68.08	68.11	2074099.0
2013-04-19 12:00:00	QQQ	ETF	68.11	68.17	68.0	68.04	1800733.0
2013-04-19 12:30:00	QQQ	ETF	68.0499	68.075	67.95	68.0	873653.0

> showing 50 of 10,275 rows — these rows as CSV

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