PREVIEW / etf_30min / 2011-01-21

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-21.parquet
  size:    270 KB
  rows:    9,103

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-21 04:00:00	SPY	ETF	127.95	128.0	127.85	128.0	1300.0
2011-01-21 05:00:00	SPY	ETF	128.07	128.1	128.07	128.1	600.0
2011-01-21 05:30:00	SPY	ETF	128.18	128.27	128.18	128.27	1700.0
2011-01-21 06:00:00	SPY	ETF	128.19	128.19	128.16	128.19	4000.0
2011-01-21 06:30:00	SPY	ETF	128.24	128.46	128.24	128.42	33767.0
2011-01-21 07:00:00	SPY	ETF	128.42	128.52	128.31	128.41	215750.0
2011-01-21 07:30:00	SPY	ETF	128.42	128.7	128.41	128.64	381335.0
2011-01-21 08:00:00	SPY	ETF	128.62	128.68	128.23	128.63	859972.0
2011-01-21 08:30:00	SPY	ETF	128.62	128.74	128.53	128.71	1309825.0
2011-01-21 09:00:00	SPY	ETF	128.72	128.99	128.72	128.88	2339825.0
2011-01-21 09:30:00	SPY	ETF	128.88	129.13	128.73	129.11	19966398.0
2011-01-21 10:00:00	SPY	ETF	129.11	129.17	128.71	128.725	14014855.0
2011-01-21 10:30:00	SPY	ETF	128.72	128.84	128.57	128.65	11868775.0
2011-01-21 11:00:00	SPY	ETF	128.66	128.77	128.44	128.6	10015084.0
2011-01-21 11:30:00	SPY	ETF	128.61	128.66	128.3	128.43	8884477.0
2011-01-21 12:00:00	SPY	ETF	128.42	128.67	128.36	128.64	6334063.0
2011-01-21 12:30:00	SPY	ETF	128.635	128.64	128.26	128.4774	6823330.0
2011-01-21 13:00:00	SPY	ETF	128.48	128.59	128.36	128.4788	5039128.0
2011-01-21 13:30:00	SPY	ETF	128.47	128.62	128.43	128.56	3816102.0
2011-01-21 14:00:00	SPY	ETF	128.56	128.65	128.47	128.52	4909270.0
2011-01-21 14:30:00	SPY	ETF	128.53	128.7	128.5	128.54	8199264.0
2011-01-21 15:00:00	SPY	ETF	128.54	128.65	128.48	128.4995	8044659.0
2011-01-21 15:30:00	SPY	ETF	128.5	128.51	128.23	128.4	21561761.0
2011-01-21 16:00:00	SPY	ETF	128.39	128.985	128.28	128.31	10017729.0
2011-01-21 16:30:00	SPY	ETF	128.31	128.4	128.3	128.3	3666223.0
2011-01-21 17:00:00	SPY	ETF	128.32	128.35	128.31	128.35	379232.0
2011-01-21 17:30:00	SPY	ETF	128.36	128.37	128.25	128.27	105041.0
2011-01-21 18:00:00	SPY	ETF	128.27	128.27	128.25	128.27	20100.0
2011-01-21 18:30:00	SPY	ETF	128.26	128.28	128.25	128.28	25900.0
2011-01-21 19:00:00	SPY	ETF	128.28	128.3	128.25	128.29	9300.0
2011-01-21 19:30:00	SPY	ETF	128.29	128.37	128.29	128.29	35437.0
2011-01-21 04:00:00	QQQ	ETF	56.03	56.03	56.0	56.0	940.0
2011-01-21 06:30:00	QQQ	ETF	56.15	56.21	56.15	56.21	7550.0
2011-01-21 07:00:00	QQQ	ETF	56.22	56.23	56.22	56.23	13900.0
2011-01-21 07:30:00	QQQ	ETF	56.23	56.36	56.23	56.36	221352.0
2011-01-21 08:00:00	QQQ	ETF	56.35	56.36	56.28	56.35	272796.0
2011-01-21 08:30:00	QQQ	ETF	56.35	56.44	56.33	56.42	939412.0
2011-01-21 09:00:00	QQQ	ETF	56.43	56.49	56.39	56.39	505621.0
2011-01-21 09:30:00	QQQ	ETF	56.39	56.49	56.32	56.46	6166624.0
2011-01-21 10:00:00	QQQ	ETF	56.45	56.49	56.22	56.22	5127712.0
2011-01-21 10:30:00	QQQ	ETF	56.23	56.27	56.15	56.155	4074527.0
2011-01-21 11:00:00	QQQ	ETF	56.15	56.23	56.01	56.09	3448426.0
2011-01-21 11:30:00	QQQ	ETF	56.09	56.13	55.95	55.999	3471510.0
2011-01-21 12:00:00	QQQ	ETF	55.995	56.08	55.93	56.041	2521136.0
2011-01-21 12:30:00	QQQ	ETF	56.0495	56.0595	55.82	55.92	3479238.0
2011-01-21 13:00:00	QQQ	ETF	55.93	55.96	55.82	55.89	2112486.0
2011-01-21 13:30:00	QQQ	ETF	55.885	55.95	55.83	55.8898	1626221.0
2011-01-21 14:00:00	QQQ	ETF	55.89	55.949	55.85	55.8932	2147221.0
2011-01-21 14:30:00	QQQ	ETF	55.89	55.98	55.88	55.9089	2212047.0
2011-01-21 15:00:00	QQQ	ETF	55.9	55.94	55.79	55.81	2811049.0

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

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