PREVIEW / etf_30min / 2012-10-12

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-12.parquet
  size:    274 KB
  rows:    9,158

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-10-12 04:00:00	SPY	ETF	143.84	143.86	143.67	143.67	600.0
2012-10-12 04:30:00	SPY	ETF	143.68	143.68	143.68	143.68	100.0
2012-10-12 05:00:00	SPY	ETF	143.77	143.8	143.58	143.58	18675.0
2012-10-12 05:30:00	SPY	ETF	143.72	143.72	143.66	143.72	20400.0
2012-10-12 06:00:00	SPY	ETF	143.68	143.81	143.68	143.8	114200.0
2012-10-12 06:30:00	SPY	ETF	143.81	143.94	143.78	143.89	157833.0
2012-10-12 07:00:00	SPY	ETF	143.89	143.9	143.75	143.8	90988.0
2012-10-12 07:30:00	SPY	ETF	143.83	144.02	143.74	144.01	281506.0
2012-10-12 08:00:00	SPY	ETF	144.01	144.01	143.78	143.78	422703.0
2012-10-12 08:30:00	SPY	ETF	143.8	143.82	143.63	143.71	1011744.0
2012-10-12 09:00:00	SPY	ETF	143.69	143.69	143.45	143.46	868410.0
2012-10-12 09:30:00	SPY	ETF	143.46	143.82	143.25	143.779	16179771.0
2012-10-12 10:00:00	SPY	ETF	143.78	143.95	143.42	143.49	10522477.0
2012-10-12 10:30:00	SPY	ETF	143.5	143.66	143.35	143.44	7476509.0
2012-10-12 11:00:00	SPY	ETF	143.45	143.472	143.01	143.02	9883923.0
2012-10-12 11:30:00	SPY	ETF	143.02	143.03	142.58	142.839	13716359.0
2012-10-12 12:00:00	SPY	ETF	142.84	142.99	142.77	142.81	7181475.0
2012-10-12 12:30:00	SPY	ETF	142.8001	142.94	142.72	142.855	3969302.0
2012-10-12 13:00:00	SPY	ETF	142.85	142.86	142.66	142.782	3731542.0
2012-10-12 13:30:00	SPY	ETF	142.7801	142.92	142.63	142.9	5480065.0
2012-10-12 14:00:00	SPY	ETF	142.9	143.05	142.79	143.02	4722679.0
2012-10-12 14:30:00	SPY	ETF	143.02	143.47	142.92	143.052	6087078.0
2012-10-12 15:00:00	SPY	ETF	143.05	143.1	142.87	142.99	5079840.0
2012-10-12 15:30:00	SPY	ETF	142.99	143.04	142.8	142.89	12969440.0
2012-10-12 16:00:00	SPY	ETF	142.88	143.1942	142.65	142.78	9188352.0
2012-10-12 16:30:00	SPY	ETF	142.77	143.5981	142.6747	142.75	1439430.0
2012-10-12 17:00:00	SPY	ETF	142.76	142.81	142.74	142.76	153601.0
2012-10-12 17:30:00	SPY	ETF	142.77	142.85	142.76	142.84	492327.0
2012-10-12 18:00:00	SPY	ETF	142.87	142.88	142.84	142.86	89404.0
2012-10-12 18:30:00	SPY	ETF	142.86	142.87	142.82	142.82	6048.0
2012-10-12 19:00:00	SPY	ETF	142.85	142.85	142.81	142.82	3684.0
2012-10-12 19:30:00	SPY	ETF	142.82	142.82	142.8	142.8	19050.0
2012-10-12 04:00:00	QQQ	ETF	66.73	66.73	66.73	66.73	100.0
2012-10-12 06:30:00	QQQ	ETF	66.78	66.78	66.78	66.78	600.0
2012-10-12 07:00:00	QQQ	ETF	66.82	66.82	66.76	66.79	25920.0
2012-10-12 07:30:00	QQQ	ETF	66.79	66.85	66.77	66.85	10400.0
2012-10-12 08:00:00	QQQ	ETF	66.84	66.88	66.82	66.84	77626.0
2012-10-12 08:30:00	QQQ	ETF	66.9	66.9	66.76	66.82	137656.0
2012-10-12 09:00:00	QQQ	ETF	66.8	66.8	66.68	66.73	187150.0
2012-10-12 09:30:00	QQQ	ETF	66.73	66.99	66.6117	66.99	3540607.0
2012-10-12 10:00:00	QQQ	ETF	66.99	67.06	66.84	66.875	2361963.0
2012-10-12 10:30:00	QQQ	ETF	66.89	67.02	66.84	66.96	1571003.0
2012-10-12 11:00:00	QQQ	ETF	66.97	66.97	66.66	66.715	1706846.0
2012-10-12 11:30:00	QQQ	ETF	66.7201	66.75	66.55	66.7485	2147730.0
2012-10-12 12:00:00	QQQ	ETF	66.74	66.81	66.68	66.7	925601.0
2012-10-12 12:30:00	QQQ	ETF	66.7	66.8	66.67	66.721	1092412.0
2012-10-12 13:00:00	QQQ	ETF	66.72	66.73	66.6	66.66	1263120.0
2012-10-12 13:30:00	QQQ	ETF	66.67	66.77	66.61	66.76	1238243.0
2012-10-12 14:00:00	QQQ	ETF	66.76	66.84	66.7	66.81	965446.0
2012-10-12 14:30:00	QQQ	ETF	66.81	66.91	66.775	66.85	1013875.0

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

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