PREVIEW / etf_30min / 2013-01-23

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-23.parquet
  size:    307 KB
  rows:    10,576

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-23 04:00:00	SPY	ETF	149.21	149.21	148.94	149.1	9684.0
2013-01-23 04:30:00	SPY	ETF	149.13	149.2	149.13	149.2	500.0
2013-01-23 05:00:00	SPY	ETF	149.18	149.18	149.17	149.18	4720.0
2013-01-23 05:30:00	SPY	ETF	149.22	149.22	149.14	149.17	17500.0
2013-01-23 06:00:00	SPY	ETF	149.17	149.17	149.14	149.17	17100.0
2013-01-23 06:30:00	SPY	ETF	149.17	149.18	149.17	149.17	11838.0
2013-01-23 07:00:00	SPY	ETF	149.16	149.3	149.16	149.3	69918.0
2013-01-23 07:30:00	SPY	ETF	149.27	149.27	149.14	149.14	99008.0
2013-01-23 08:00:00	SPY	ETF	149.14	149.3	149.01	149.07	451558.0
2013-01-23 08:30:00	SPY	ETF	149.07	149.17	149.07	149.09	212999.0
2013-01-23 09:00:00	SPY	ETF	149.09	149.15	149.02	149.14	363153.0
2013-01-23 09:30:00	SPY	ETF	149.13	149.24	149.05	149.13	9641180.0
2013-01-23 10:00:00	SPY	ETF	149.118	149.33	149.02	149.0373	7363954.0
2013-01-23 10:30:00	SPY	ETF	149.039	149.045	148.86	149.007	7510690.0
2013-01-23 11:00:00	SPY	ETF	149.01	149.14	148.95	148.97	6329814.0
2013-01-23 11:30:00	SPY	ETF	148.97	149.16	148.94	149.09	4509822.0
2013-01-23 12:00:00	SPY	ETF	149.0901	149.19	149.05	149.061	3961279.0
2013-01-23 12:30:00	SPY	ETF	149.061	149.23	149.04	149.225	4009013.0
2013-01-23 13:00:00	SPY	ETF	149.221	149.33	149.2	149.225	3976823.0
2013-01-23 13:30:00	SPY	ETF	149.225	149.32	149.21	149.3001	2574225.0
2013-01-23 14:00:00	SPY	ETF	149.31	149.36	149.23	149.32	4498178.0
2013-01-23 14:30:00	SPY	ETF	149.32	149.49	149.31	149.47	6093666.0
2013-01-23 15:00:00	SPY	ETF	149.47	149.5	149.36	149.395	5909045.0
2013-01-23 15:30:00	SPY	ETF	149.39	149.4	149.24	149.37	12708558.0
2013-01-23 16:00:00	SPY	ETF	149.36	149.59	149.2118	149.42	10386856.0
2013-01-23 16:30:00	SPY	ETF	149.43	149.52	148.91	148.92	7074729.0
2013-01-23 17:00:00	SPY	ETF	148.95	149.0	148.72	148.72	326344.0
2013-01-23 17:30:00	SPY	ETF	148.73	148.79	148.65	148.71	600764.0
2013-01-23 18:00:00	SPY	ETF	148.74	148.83	148.71	148.78	102200.0
2013-01-23 18:30:00	SPY	ETF	148.77	148.86	148.74	148.85	29232.0
2013-01-23 19:00:00	SPY	ETF	148.81	148.84	148.79	148.8	19616.0
2013-01-23 19:30:00	SPY	ETF	148.82	148.91	148.78	148.79	158407.0
2013-01-23 07:00:00	QQQ	ETF	67.55	67.58	67.54	67.55	7300.0
2013-01-23 07:30:00	QQQ	ETF	67.54	67.55	67.52	67.53	48026.0
2013-01-23 08:00:00	QQQ	ETF	67.52	67.56	67.45	67.47	163067.0
2013-01-23 08:30:00	QQQ	ETF	67.48	67.58	67.48	67.57	152457.0
2013-01-23 09:00:00	QQQ	ETF	67.56	67.61	67.52	67.54	206160.0
2013-01-23 09:30:00	QQQ	ETF	67.55	67.65	67.46	67.62	3086408.0
2013-01-23 10:00:00	QQQ	ETF	67.62	67.79	67.595	67.61	3144305.0
2013-01-23 10:30:00	QQQ	ETF	67.62	67.62	67.5	67.5896	2496772.0
2013-01-23 11:00:00	QQQ	ETF	67.58	67.66	67.52	67.53	2160075.0
2013-01-23 11:30:00	QQQ	ETF	67.53	67.59	67.52	67.56	1069591.0
2013-01-23 12:00:00	QQQ	ETF	67.55	67.59	67.52	67.54	714093.0
2013-01-23 12:30:00	QQQ	ETF	67.539	67.6	67.4899	67.6	1881440.0
2013-01-23 13:00:00	QQQ	ETF	67.61	67.67	67.5799	67.615	965113.0
2013-01-23 13:30:00	QQQ	ETF	67.615	67.65	67.58	67.62	943934.0
2013-01-23 14:00:00	QQQ	ETF	67.62	67.64	67.549	67.6	700338.0
2013-01-23 14:30:00	QQQ	ETF	67.6	67.71	67.59	67.69	1262618.0
2013-01-23 15:00:00	QQQ	ETF	67.69	67.7201	67.66	67.67	1728401.0
2013-01-23 15:30:00	QQQ	ETF	67.67	67.67	67.58	67.59	3437902.0

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

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