PREVIEW / etf_30min / 2012-12-05

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-05.parquet
  size:    290 KB
  rows:    9,872

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-05 04:00:00	SPY	ETF	141.75	141.86	141.75	141.84	14637.0
2012-12-05 04:30:00	SPY	ETF	141.82	141.86	141.56	141.56	17102.0
2012-12-05 05:00:00	SPY	ETF	141.57	141.66	141.57	141.66	15390.0
2012-12-05 05:30:00	SPY	ETF	141.62	141.62	141.52	141.57	3400.0
2012-12-05 06:00:00	SPY	ETF	141.52	141.69	141.52	141.69	16441.0
2012-12-05 06:30:00	SPY	ETF	141.75	141.75	141.55	141.61	8352.0
2012-12-05 07:00:00	SPY	ETF	141.66	141.66	141.54	141.62	22835.0
2012-12-05 07:30:00	SPY	ETF	141.64	141.81	141.61	141.69	301912.0
2012-12-05 08:00:00	SPY	ETF	141.68	141.73	141.48	141.59	566133.0
2012-12-05 08:30:00	SPY	ETF	141.6	141.65	141.5	141.5	235702.0
2012-12-05 09:00:00	SPY	ETF	141.5	141.505	141.32	141.37	407353.0
2012-12-05 09:30:00	SPY	ETF	141.37	141.67	141.16	141.18	13941972.0
2012-12-05 10:00:00	SPY	ETF	141.18	141.46	140.97	141.0	13366291.0
2012-12-05 10:30:00	SPY	ETF	140.991	141.14	140.37	140.665	14078229.0
2012-12-05 11:00:00	SPY	ETF	140.67	141.1	140.53	140.99	10561694.0
2012-12-05 11:30:00	SPY	ETF	140.99	141.72	140.99	141.6678	12865887.0
2012-12-05 12:00:00	SPY	ETF	141.66	142.05	141.65	141.7	11051267.0
2012-12-05 12:30:00	SPY	ETF	141.692	142.16	141.69	142.0	9233383.0
2012-12-05 13:00:00	SPY	ETF	142.0	142.07	141.83	141.851	6663656.0
2012-12-05 13:30:00	SPY	ETF	141.85	141.95	141.7	141.721	7854695.0
2012-12-05 14:00:00	SPY	ETF	141.721	142.02	141.72	141.8	4226360.0
2012-12-05 14:30:00	SPY	ETF	141.8	141.96	141.75	141.7999	4516998.0
2012-12-05 15:00:00	SPY	ETF	141.7999	142.13	141.77	141.92	11657834.0
2012-12-05 15:30:00	SPY	ETF	141.92	141.97	141.31	141.48	15636853.0
2012-12-05 16:00:00	SPY	ETF	141.48	141.8735	140.43	141.49	4363022.0
2012-12-05 16:30:00	SPY	ETF	141.49	141.54	141.33	141.35	2917831.0
2012-12-05 17:00:00	SPY	ETF	141.34	141.39	141.34	141.39	1623303.0
2012-12-05 17:30:00	SPY	ETF	141.37	141.4	141.27	141.27	69685.0
2012-12-05 18:00:00	SPY	ETF	141.33	141.49	141.3	141.43	66095.0
2012-12-05 18:30:00	SPY	ETF	141.46	141.58	141.46	141.56	39519.0
2012-12-05 19:00:00	SPY	ETF	141.53	141.55	141.33	141.37	49690.0
2012-12-05 19:30:00	SPY	ETF	141.45	141.51	141.27	141.31	28519.0
2012-12-05 04:00:00	QQQ	ETF	65.84	65.85	65.84	65.85	1050.0
2012-12-05 05:30:00	QQQ	ETF	65.63	65.63	65.6	65.6	25000.0
2012-12-05 06:00:00	QQQ	ETF	65.64	65.69	65.64	65.69	800.0
2012-12-05 07:00:00	QQQ	ETF	65.68	65.68	65.61	65.63	75400.0
2012-12-05 07:30:00	QQQ	ETF	65.64	65.7	65.64	65.69	55950.0
2012-12-05 08:00:00	QQQ	ETF	65.66	65.67	65.58	65.6	99894.0
2012-12-05 08:30:00	QQQ	ETF	65.61	65.65	65.58	65.605	72138.0
2012-12-05 09:00:00	QQQ	ETF	65.59	65.6	65.52	65.54	129799.0
2012-12-05 09:30:00	QQQ	ETF	65.53	65.55	65.04	65.14	6238292.0
2012-12-05 10:00:00	QQQ	ETF	65.135	65.24	64.91	64.92	5792457.0
2012-12-05 10:30:00	QQQ	ETF	64.92	64.9899	64.55	64.7	5497539.0
2012-12-05 11:00:00	QQQ	ETF	64.71	64.97	64.63	64.89	3984826.0
2012-12-05 11:30:00	QQQ	ETF	64.9	65.21	64.9	65.1699	3037902.0
2012-12-05 12:00:00	QQQ	ETF	65.17	65.37	65.159	65.161	3288967.0
2012-12-05 12:30:00	QQQ	ETF	65.161	65.42	65.161	65.27	2041751.0
2012-12-05 13:00:00	QQQ	ETF	65.28	65.31	65.18	65.22	1304647.0
2012-12-05 13:30:00	QQQ	ETF	65.218	65.24	65.08	65.08	1581660.0
2012-12-05 14:00:00	QQQ	ETF	65.0801	65.27	65.08	65.14	1116469.0

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

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