PREVIEW / etf_30min / 2012-08-01

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-01.parquet
  size:    273 KB
  rows:    9,323

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-08-01 04:00:00	SPY	ETF	138.17	138.48	138.17	138.41	10240.0
2012-08-01 04:30:00	SPY	ETF	138.36	138.36	138.1	138.13	6100.0
2012-08-01 05:00:00	SPY	ETF	138.42	138.48	138.39	138.48	9075.0
2012-08-01 05:30:00	SPY	ETF	138.42	138.53	138.39	138.53	28040.0
2012-08-01 06:00:00	SPY	ETF	138.52	138.59	138.5	138.59	7590.0
2012-08-01 06:30:00	SPY	ETF	138.59	138.6	138.42	138.42	55000.0
2012-08-01 07:00:00	SPY	ETF	138.43	138.5	138.33	138.36	69428.0
2012-08-01 07:30:00	SPY	ETF	138.33	138.47	138.32	138.44	56260.0
2012-08-01 08:00:00	SPY	ETF	138.45	138.58	137.71	138.57	1233173.0
2012-08-01 08:30:00	SPY	ETF	138.57	138.58	137.71	138.53	466159.0
2012-08-01 09:00:00	SPY	ETF	138.55	138.74	137.71	138.7	736274.0
2012-08-01 09:30:00	SPY	ETF	138.7	138.73	138.28	138.36	10760832.0
2012-08-01 10:00:00	SPY	ETF	138.36	138.53	137.98	138.21	11434467.0
2012-08-01 10:30:00	SPY	ETF	138.21	138.57	138.13	138.46	9559952.0
2012-08-01 11:00:00	SPY	ETF	138.46	138.52	138.2	138.34	4253527.0
2012-08-01 11:30:00	SPY	ETF	138.34	138.45	138.27	138.4	3520628.0
2012-08-01 12:00:00	SPY	ETF	138.39	138.52	138.33	138.45	3813907.0
2012-08-01 12:30:00	SPY	ETF	138.46	138.52	138.38	138.47	3302381.0
2012-08-01 13:00:00	SPY	ETF	138.46	138.59	138.38	138.405	3840363.0
2012-08-01 13:30:00	SPY	ETF	138.4	138.48	138.14	138.175	3688390.0
2012-08-01 14:00:00	SPY	ETF	138.18	138.26	137.4	138.16	23777093.0
2012-08-01 14:30:00	SPY	ETF	138.16	138.19	137.64	137.99	14160148.0
2012-08-01 15:00:00	SPY	ETF	137.98	138.33	137.85	138.25	10804660.0
2012-08-01 15:30:00	SPY	ETF	138.25	138.31	137.61	137.62	17846996.0
2012-08-01 16:00:00	SPY	ETF	137.62	138.3	137.55	137.58	10351523.0
2012-08-01 16:30:00	SPY	ETF	137.58	137.66	137.531	137.59	2585542.0
2012-08-01 17:00:00	SPY	ETF	137.61	137.66	137.47	137.61	81920.0
2012-08-01 17:30:00	SPY	ETF	137.61	137.67	137.6	137.65	89115.0
2012-08-01 18:00:00	SPY	ETF	137.64	137.77	137.59	137.73	57436.0
2012-08-01 18:30:00	SPY	ETF	137.75	137.8	137.75	137.77	38970.0
2012-08-01 19:00:00	SPY	ETF	137.79	137.88	137.73	137.86	14102.0
2012-08-01 19:30:00	SPY	ETF	137.85	137.88	137.82	137.87	15401.0
2012-08-01 04:00:00	QQQ	ETF	64.77	65.11	64.77	65.11	521.0
2012-08-01 06:00:00	QQQ	ETF	65.13	65.14	65.13	65.14	2000.0
2012-08-01 06:30:00	QQQ	ETF	65.15	65.15	65.08	65.08	2400.0
2012-08-01 07:00:00	QQQ	ETF	65.08	65.08	64.98	65.04	195682.0
2012-08-01 07:30:00	QQQ	ETF	65.03	65.05	65.03	65.05	2400.0
2012-08-01 08:00:00	QQQ	ETF	65.05	65.2	64.8	65.2	860365.0
2012-08-01 08:30:00	QQQ	ETF	65.2	65.21	65.1	65.16	79345.0
2012-08-01 09:00:00	QQQ	ETF	65.17	65.26	65.17	65.26	55213.0
2012-08-01 09:30:00	QQQ	ETF	65.25	65.2799	64.91	64.95	2797850.0
2012-08-01 10:00:00	QQQ	ETF	64.94	65.07	64.75	64.84	2380968.0
2012-08-01 10:30:00	QQQ	ETF	64.85	65.01	64.8	64.91	1752995.0
2012-08-01 11:00:00	QQQ	ETF	64.9	64.95	64.76	64.82	1705937.0
2012-08-01 11:30:00	QQQ	ETF	64.82	64.87	64.74	64.78	821202.0
2012-08-01 12:00:00	QQQ	ETF	64.7895	64.91	64.74	64.885	680034.0
2012-08-01 12:30:00	QQQ	ETF	64.89	64.94	64.84	64.88	869254.0
2012-08-01 13:00:00	QQQ	ETF	64.8809	64.95	64.81	64.84	1195879.0
2012-08-01 13:30:00	QQQ	ETF	64.84	64.86	64.71	64.73	841822.0
2012-08-01 14:00:00	QQQ	ETF	64.73	64.82	64.35	64.81	5473317.0

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

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