PREVIEW / etf_30min / 2012-06-29

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-29.parquet
  size:    303 KB
  rows:    10,193

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-06-29 04:00:00	SPY	ETF	134.2	134.64	134.2	134.45	16456.0
2012-06-29 04:30:00	SPY	ETF	134.44	134.47	134.32	134.47	10998.0
2012-06-29 05:00:00	SPY	ETF	134.41	134.49	134.3	134.34	14410.0
2012-06-29 05:30:00	SPY	ETF	134.4	134.61	134.4	134.57	16868.0
2012-06-29 06:00:00	SPY	ETF	134.51	134.52	134.35	134.45	79950.0
2012-06-29 06:30:00	SPY	ETF	134.44	134.65	134.39	134.62	58602.0
2012-06-29 07:00:00	SPY	ETF	134.62	134.9	134.62	134.8	639278.0
2012-06-29 07:30:00	SPY	ETF	134.81	134.86	134.54	134.69	1019272.0
2012-06-29 08:00:00	SPY	ETF	134.69	135.09	134.67	135.0	1730434.0
2012-06-29 08:30:00	SPY	ETF	135.01	135.46	134.93	135.23	2831129.0
2012-06-29 09:00:00	SPY	ETF	135.25	135.29	134.28	135.21	2918158.0
2012-06-29 09:30:00	SPY	ETF	135.2	135.29	134.85	135.06	26215888.0
2012-06-29 10:00:00	SPY	ETF	135.06	135.59	135.06	135.5	18706472.0
2012-06-29 10:30:00	SPY	ETF	135.495	135.52	135.25	135.37	11175127.0
2012-06-29 11:00:00	SPY	ETF	135.37	135.48	135.26	135.43	12536349.0
2012-06-29 11:30:00	SPY	ETF	135.44	135.54	135.35	135.42	6934668.0
2012-06-29 12:00:00	SPY	ETF	135.425	135.47	135.32	135.4	7783543.0
2012-06-29 12:30:00	SPY	ETF	135.41	135.49	135.32	135.475	6051454.0
2012-06-29 13:00:00	SPY	ETF	135.49	135.67	135.45	135.59	7705182.0
2012-06-29 13:30:00	SPY	ETF	135.59	135.66	135.57	135.61	8161308.0
2012-06-29 14:00:00	SPY	ETF	135.61	135.85	135.51	135.8	9554780.0
2012-06-29 14:30:00	SPY	ETF	135.8	135.84	135.7	135.83	12204144.0
2012-06-29 15:00:00	SPY	ETF	135.839	135.839	135.63	135.67	8335763.0
2012-06-29 15:30:00	SPY	ETF	135.67	136.24	135.55	136.22	36060906.0
2012-06-29 16:00:00	SPY	ETF	136.22	136.5	135.435	136.38	20311219.0
2012-06-29 16:30:00	SPY	ETF	136.38	136.42	136.201	136.37	6305307.0
2012-06-29 17:00:00	SPY	ETF	136.37	136.44	136.35	136.42	785881.0
2012-06-29 17:30:00	SPY	ETF	136.4	136.43	135.1434	136.38	131418.0
2012-06-29 18:00:00	SPY	ETF	136.39	136.48	136.37	136.39	89548.0
2012-06-29 18:30:00	SPY	ETF	136.39	136.4	136.37	136.37	24056.0
2012-06-29 19:00:00	SPY	ETF	136.38	136.4	136.35	136.38	42067.0
2012-06-29 19:30:00	SPY	ETF	136.39	136.49	136.36	136.38	38513.0
2012-06-29 04:00:00	QQQ	ETF	62.65	62.9	62.65	62.83	3500.0
2012-06-29 05:30:00	QQQ	ETF	63.01	63.01	62.68	62.68	640.0
2012-06-29 06:00:00	QQQ	ETF	62.88	62.91	62.88	62.89	7200.0
2012-06-29 06:30:00	QQQ	ETF	62.87	62.99	62.87	62.95	2322.0
2012-06-29 07:00:00	QQQ	ETF	62.96	63.11	62.96	63.09	48127.0
2012-06-29 07:30:00	QQQ	ETF	63.07	63.08	62.96	63.02	133731.0
2012-06-29 08:00:00	QQQ	ETF	63.02	63.23	63.01	63.17	379955.0
2012-06-29 08:30:00	QQQ	ETF	63.17	63.35	63.13	63.29	376314.0
2012-06-29 09:00:00	QQQ	ETF	63.3	63.36	63.23	63.35	271558.0
2012-06-29 09:30:00	QQQ	ETF	63.36	63.51	63.21	63.35	6647716.0
2012-06-29 10:00:00	QQQ	ETF	63.36	63.67	63.36	63.63	5846049.0
2012-06-29 10:30:00	QQQ	ETF	63.63	63.68	63.53	63.61	3369740.0
2012-06-29 11:00:00	QQQ	ETF	63.62	63.74	63.582	63.73	3200246.0
2012-06-29 11:30:00	QQQ	ETF	63.73	63.79	63.67	63.69	1466656.0
2012-06-29 12:00:00	QQQ	ETF	63.69	63.74	63.67	63.73	988332.0
2012-06-29 12:30:00	QQQ	ETF	63.73	63.81	63.69	63.795	2087600.0
2012-06-29 13:00:00	QQQ	ETF	63.8	63.86	63.79	63.81	1350894.0
2012-06-29 13:30:00	QQQ	ETF	63.81	63.85	63.79	63.84	873747.0

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

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