PREVIEW / etf_30min / 2012-12-17

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-17.parquet
  size:    297 KB
  rows:    10,136

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
2012-12-17 04:00:00	SPY	ETF	142.37	142.51	142.37	142.51	1043.0
2012-12-17 04:30:00	SPY	ETF	142.37	142.37	142.36	142.36	300.0
2012-12-17 05:00:00	SPY	ETF	142.33	142.35	142.22	142.22	3500.0
2012-12-17 05:30:00	SPY	ETF	142.23	142.4	142.23	142.36	23800.0
2012-12-17 06:00:00	SPY	ETF	142.35	142.44	142.26	142.43	35623.0
2012-12-17 06:30:00	SPY	ETF	142.45	142.55	142.43	142.48	29622.0
2012-12-17 07:00:00	SPY	ETF	142.48	142.55	142.41	142.55	113700.0
2012-12-17 07:30:00	SPY	ETF	142.55	142.55	142.31	142.5	69132.0
2012-12-17 08:00:00	SPY	ETF	142.51	142.82	142.41	142.64	880637.0
2012-12-17 08:30:00	SPY	ETF	142.76	142.9	142.56	142.58	670358.0
2012-12-17 09:00:00	SPY	ETF	142.57	142.64	142.45	142.48	576606.0
2012-12-17 09:30:00	SPY	ETF	142.47	143.05	142.43	142.93	15283190.0
2012-12-17 10:00:00	SPY	ETF	142.93	143.1	142.68	142.745	7429197.0
2012-12-17 10:30:00	SPY	ETF	142.74	142.95	142.72	142.82	5614700.0
2012-12-17 11:00:00	SPY	ETF	142.81	143.19	142.8	143.02	6325335.0
2012-12-17 11:30:00	SPY	ETF	142.99	143.42	142.97	143.28	8362695.0
2012-12-17 12:00:00	SPY	ETF	143.28	143.54	143.24	143.485	5207167.0
2012-12-17 12:30:00	SPY	ETF	143.49	143.52	143.37	143.375	2477699.0
2012-12-17 13:00:00	SPY	ETF	143.38	143.43	143.24	143.291	4972868.0
2012-12-17 13:30:00	SPY	ETF	143.291	143.305	143.02	143.055	8918253.0
2012-12-17 14:00:00	SPY	ETF	143.05	143.31	142.91	143.02	9893933.0
2012-12-17 14:30:00	SPY	ETF	143.02	143.18	143.01	143.17	6503992.0
2012-12-17 15:00:00	SPY	ETF	143.17	143.33	143.12	143.245	6039840.0
2012-12-17 15:30:00	SPY	ETF	143.24	143.85	143.225	143.77	24562295.0
2012-12-17 16:00:00	SPY	ETF	143.77	144.06	143.7328	144.01	6259632.0
2012-12-17 16:30:00	SPY	ETF	144.01	144.09	142.0566	144.07	2666568.0
2012-12-17 17:00:00	SPY	ETF	144.08	144.13	143.91	144.09	7218767.0
2012-12-17 17:30:00	SPY	ETF	144.09	144.13	144.07	144.09	1129114.0
2012-12-17 18:00:00	SPY	ETF	144.08	144.1	144.04	144.06	66703.0
2012-12-17 18:30:00	SPY	ETF	144.06	144.09	143.79	144.04	376766.0
2012-12-17 19:00:00	SPY	ETF	144.03	144.05	144.01	144.05	28465.0
2012-12-17 19:30:00	SPY	ETF	144.04	144.22	144.02	144.22	92386.0
2012-12-17 05:00:00	QQQ	ETF	64.59	64.59	64.39	64.39	17400.0
2012-12-17 05:30:00	QQQ	ETF	64.48	64.49	64.48	64.49	8634.0
2012-12-17 06:00:00	QQQ	ETF	64.48	64.48	64.48	64.48	2166.0
2012-12-17 07:00:00	QQQ	ETF	64.54	64.6	64.54	64.56	57100.0
2012-12-17 07:30:00	QQQ	ETF	64.58	64.65	64.55	64.65	39434.0
2012-12-17 08:00:00	QQQ	ETF	64.65	64.89	64.57	64.87	203788.0
2012-12-17 08:30:00	QQQ	ETF	64.87	64.94	64.79	64.79	262424.0
2012-12-17 09:00:00	QQQ	ETF	64.8	64.8	64.73	64.73	145858.0
2012-12-17 09:30:00	QQQ	ETF	64.73	65.12	64.66	64.942	8674605.0
2012-12-17 10:00:00	QQQ	ETF	64.94	64.99	64.692	64.8	2859915.0
2012-12-17 10:30:00	QQQ	ETF	64.8	64.94	64.77	64.91	2256076.0
2012-12-17 11:00:00	QQQ	ETF	64.9	65.13	64.88	64.98	2644643.0
2012-12-17 11:30:00	QQQ	ETF	64.99	65.35	64.98	65.31	3127618.0
2012-12-17 12:00:00	QQQ	ETF	65.3199	65.4681	65.26	65.41	2235155.0
2012-12-17 12:30:00	QQQ	ETF	65.4	65.45	65.33	65.34	1265977.0
2012-12-17 13:00:00	QQQ	ETF	65.34	65.39	65.22	65.2499	1378681.0
2012-12-17 13:30:00	QQQ	ETF	65.25	65.259	65.09	65.1001	1376554.0
2012-12-17 14:00:00	QQQ	ETF	65.1	65.24	64.99	65.0655	2219598.0

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

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