PREVIEW / etf_30min / 2014-01-22

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-22.parquet
  size:    341 KB
  rows:    11,569

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
2014-01-22 04:00:00	SPY	ETF	184.3	184.33	184.3	184.31	2781.0
2014-01-22 04:30:00	SPY	ETF	184.16	184.16	184.16	184.16	2000.0
2014-01-22 05:00:00	SPY	ETF	184.21	184.21	184.11	184.11	6781.0
2014-01-22 05:30:00	SPY	ETF	184.11	184.11	183.97	184.01	14470.0
2014-01-22 06:00:00	SPY	ETF	183.92	184.01	183.9	184.01	4460.0
2014-01-22 06:30:00	SPY	ETF	184.07	184.1	184.06	184.06	1313.0
2014-01-22 07:00:00	SPY	ETF	184.14	184.2	184.06	184.2	32069.0
2014-01-22 07:30:00	SPY	ETF	184.19	184.19	184.01	184.04	97467.0
2014-01-22 08:00:00	SPY	ETF	184.06	184.11	183.99	184.11	93028.0
2014-01-22 08:30:00	SPY	ETF	184.11	184.36	184.1	184.29	183402.0
2014-01-22 09:00:00	SPY	ETF	184.3	184.6	184.29	184.5	645579.0
2014-01-22 09:30:00	SPY	ETF	184.49	184.52	184.11	184.23	8126613.0
2014-01-22 10:00:00	SPY	ETF	184.23	184.45	184.03	184.41	5696619.0
2014-01-22 10:30:00	SPY	ETF	184.41	184.41	183.93	183.989	5715851.0
2014-01-22 11:00:00	SPY	ETF	183.98	184.12	183.91	184.09	4153790.0
2014-01-22 11:30:00	SPY	ETF	184.09	184.21	183.98	184.099	3327340.0
2014-01-22 12:00:00	SPY	ETF	184.1	184.44	184.02	184.3586	3011307.0
2014-01-22 12:30:00	SPY	ETF	184.35	184.38	184.28	184.37	2552240.0
2014-01-22 13:00:00	SPY	ETF	184.37	184.52	184.295	184.44	2609888.0
2014-01-22 13:30:00	SPY	ETF	184.44	184.45	184.12	184.24	3628090.0
2014-01-22 14:00:00	SPY	ETF	184.24	184.43	184.23	184.37	1769504.0
2014-01-22 14:30:00	SPY	ETF	184.36	184.41	184.2	184.34	2758928.0
2014-01-22 15:00:00	SPY	ETF	184.34	184.5	184.33	184.42	3110479.0
2014-01-22 15:30:00	SPY	ETF	184.42	184.57	184.31	184.35	7982284.0
2014-01-22 16:00:00	SPY	ETF	184.35	184.4555	183.98	184.34	2968697.0
2014-01-22 16:30:00	SPY	ETF	184.33	184.44	184.3	184.31	1361614.0
2014-01-22 17:00:00	SPY	ETF	184.33	184.34	184.17	184.24	143085.0
2014-01-22 17:30:00	SPY	ETF	184.22	184.26	184.22	184.26	138783.0
2014-01-22 18:00:00	SPY	ETF	184.26	184.52	184.26	184.49	174251.0
2014-01-22 18:30:00	SPY	ETF	184.52	184.74	184.5	184.71	167305.0
2014-01-22 19:00:00	SPY	ETF	184.64	184.67	184.6	184.67	29710.0
2014-01-22 19:30:00	SPY	ETF	184.64	184.64	184.54	184.55	130865.0
2014-01-22 04:00:00	QQQ	ETF	88.6	88.62	88.6	88.62	333.0
2014-01-22 06:30:00	QQQ	ETF	88.52	88.54	88.52	88.54	3100.0
2014-01-22 07:00:00	QQQ	ETF	88.55	88.6	88.54	88.6	12900.0
2014-01-22 07:30:00	QQQ	ETF	88.61	88.61	88.52	88.52	8000.0
2014-01-22 08:00:00	QQQ	ETF	88.57	88.6	88.51	88.6	21325.0
2014-01-22 08:30:00	QQQ	ETF	88.6	88.73	88.6	88.7	78184.0
2014-01-22 09:00:00	QQQ	ETF	88.7	88.8	88.55	88.76	219994.0
2014-01-22 09:30:00	QQQ	ETF	88.75	88.78	88.58	88.645	3052579.0
2014-01-22 10:00:00	QQQ	ETF	88.65	88.82	88.52	88.79	2262767.0
2014-01-22 10:30:00	QQQ	ETF	88.79	88.82	88.59	88.65	1927135.0
2014-01-22 11:00:00	QQQ	ETF	88.65	88.77	88.6166	88.7101	1287168.0
2014-01-22 11:30:00	QQQ	ETF	88.72	88.81	88.7	88.78	1203107.0
2014-01-22 12:00:00	QQQ	ETF	88.78	88.945	88.739	88.89	1056992.0
2014-01-22 12:30:00	QQQ	ETF	88.8999	88.96	88.86	88.9299	618092.0
2014-01-22 13:00:00	QQQ	ETF	88.92	89.0	88.8899	88.94	573133.0
2014-01-22 13:30:00	QQQ	ETF	88.94	88.95	88.76	88.82	1403092.0
2014-01-22 14:00:00	QQQ	ETF	88.83	88.92	88.82	88.87	800946.0
2014-01-22 14:30:00	QQQ	ETF	88.88	88.89	88.7701	88.81	857205.0

> showing 50 of 11,569 rows — these rows as CSV

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