PREVIEW / etf_30min / 2013-01-30

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-30.parquet
  size:    312 KB
  rows:    10,656

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-01-30 04:00:00	SPY	ETF	150.88	150.93	150.88	150.93	380.0
2013-01-30 04:30:00	SPY	ETF	150.95	150.95	150.95	150.95	500.0
2013-01-30 05:00:00	SPY	ETF	150.88	150.9	150.83	150.85	13500.0
2013-01-30 05:30:00	SPY	ETF	150.87	150.95	150.87	150.93	4055.0
2013-01-30 06:00:00	SPY	ETF	150.96	150.96	150.83	150.85	23436.0
2013-01-30 06:30:00	SPY	ETF	150.83	150.91	150.83	150.9	9400.0
2013-01-30 07:00:00	SPY	ETF	150.87	150.9	150.82	150.84	27605.0
2013-01-30 07:30:00	SPY	ETF	150.84	150.86	150.72	150.73	175062.0
2013-01-30 08:00:00	SPY	ETF	150.73	150.91	150.55	150.61	1719030.0
2013-01-30 08:30:00	SPY	ETF	150.59	150.66	149.77	150.53	1912709.0
2013-01-30 09:00:00	SPY	ETF	150.53	150.65	150.51	150.65	685578.0
2013-01-30 09:30:00	SPY	ETF	150.64	150.94	150.49	150.66	13576289.0
2013-01-30 10:00:00	SPY	ETF	150.65	150.67	150.33	150.41	11710751.0
2013-01-30 10:30:00	SPY	ETF	150.4	150.47	150.27	150.44	7694688.0
2013-01-30 11:00:00	SPY	ETF	150.44	150.63	150.44	150.53	3968712.0
2013-01-30 11:30:00	SPY	ETF	150.525	150.7	150.51	150.6	5330043.0
2013-01-30 12:00:00	SPY	ETF	150.6	150.65	150.39	150.42	5266384.0
2013-01-30 12:30:00	SPY	ETF	150.42	150.74	150.38	150.71	4087794.0
2013-01-30 13:00:00	SPY	ETF	150.71	150.74	150.58	150.722	2796438.0
2013-01-30 13:30:00	SPY	ETF	150.73	150.74	150.53	150.6	1940586.0
2013-01-30 14:00:00	SPY	ETF	150.59	150.73	150.32	150.49	9818005.0
2013-01-30 14:30:00	SPY	ETF	150.5	150.57	150.2	150.41	11460698.0
2013-01-30 15:00:00	SPY	ETF	150.4	150.46	150.07	150.1499	11326404.0
2013-01-30 15:30:00	SPY	ETF	150.14	150.18	149.93	150.1	19267002.0
2013-01-30 16:00:00	SPY	ETF	150.11	150.77	149.89	149.93	7853011.0
2013-01-30 16:30:00	SPY	ETF	149.94	150.801	149.84	149.84	14053827.0
2013-01-30 17:00:00	SPY	ETF	150.7211	150.7211	149.75	149.84	1615694.0
2013-01-30 17:30:00	SPY	ETF	149.83	149.85	149.81	149.85	29333.0
2013-01-30 18:00:00	SPY	ETF	149.84	149.94	149.83	149.93	46412.0
2013-01-30 18:30:00	SPY	ETF	149.9	149.93	149.88	149.88	5600.0
2013-01-30 19:00:00	SPY	ETF	149.9	150.0	149.9	150.0	81978.0
2013-01-30 19:30:00	SPY	ETF	149.94	149.96	149.9	149.9	15644.0
2013-01-30 04:30:00	QQQ	ETF	67.3	67.3	67.3	67.3	100.0
2013-01-30 05:00:00	QQQ	ETF	67.33	67.36	67.32	67.36	1318.0
2013-01-30 06:00:00	QQQ	ETF	67.3	67.3	67.3	67.3	618.0
2013-01-30 06:30:00	QQQ	ETF	67.33	67.35	67.33	67.35	7300.0
2013-01-30 07:30:00	QQQ	ETF	67.3	67.31	67.29	67.29	25300.0
2013-01-30 08:00:00	QQQ	ETF	67.29	67.35	67.18	67.19	739855.0
2013-01-30 08:30:00	QQQ	ETF	67.19	67.22	67.0	67.14	180214.0
2013-01-30 09:00:00	QQQ	ETF	67.14	67.28	67.14	67.27	114145.0
2013-01-30 09:30:00	QQQ	ETF	67.28	67.48	67.135	67.3807	7833700.0
2013-01-30 10:00:00	QQQ	ETF	67.37	67.4	67.1	67.14	3018418.0
2013-01-30 10:30:00	QQQ	ETF	67.14	67.24	67.01	67.23	2137178.0
2013-01-30 11:00:00	QQQ	ETF	67.23	67.31	67.22	67.27	1129698.0
2013-01-30 11:30:00	QQQ	ETF	67.271	67.439	67.27	67.35	1719797.0
2013-01-30 12:00:00	QQQ	ETF	67.34	67.369	67.19	67.19	819268.0
2013-01-30 12:30:00	QQQ	ETF	67.2	67.3001	67.165	67.291	1073133.0
2013-01-30 13:00:00	QQQ	ETF	67.295	67.31	67.18	67.28	1120610.0
2013-01-30 13:30:00	QQQ	ETF	67.28	67.28	67.19	67.25	460849.0
2013-01-30 14:00:00	QQQ	ETF	67.24	67.35	67.1	67.2	2086204.0

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

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