PREVIEW / etf_30min / 2012-08-22

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-22.parquet
  size:    283 KB
  rows:    9,583

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-22 04:00:00	SPY	ETF	141.41	141.58	141.41	141.58	900.0
2012-08-22 04:30:00	SPY	ETF	141.67	141.75	141.67	141.75	1300.0
2012-08-22 05:00:00	SPY	ETF	141.7	141.7	141.58	141.58	500.0
2012-08-22 05:30:00	SPY	ETF	141.56	141.6	141.56	141.57	750.0
2012-08-22 06:00:00	SPY	ETF	141.59	141.67	141.54	141.67	27500.0
2012-08-22 06:30:00	SPY	ETF	141.68	141.71	141.43	141.43	16700.0
2012-08-22 07:00:00	SPY	ETF	141.47	141.49	141.41	141.43	75104.0
2012-08-22 07:30:00	SPY	ETF	141.44	141.52	141.44	141.47	108310.0
2012-08-22 08:00:00	SPY	ETF	141.49	141.76	141.3	141.61	1535294.0
2012-08-22 08:30:00	SPY	ETF	141.59	141.67	141.35	141.49	725926.0
2012-08-22 09:00:00	SPY	ETF	141.49	141.55	141.34	141.39	537483.0
2012-08-22 09:30:00	SPY	ETF	141.4	141.72	141.25	141.605	14657326.0
2012-08-22 10:00:00	SPY	ETF	141.605	141.71	141.46	141.69	8585568.0
2012-08-22 10:30:00	SPY	ETF	141.69	141.75	141.32	141.33	7537718.0
2012-08-22 11:00:00	SPY	ETF	141.33	141.7343	141.19	141.31	8677801.0
2012-08-22 11:30:00	SPY	ETF	141.3	141.43	141.19	141.41	3851342.0
2012-08-22 12:00:00	SPY	ETF	141.42	141.46	141.24	141.34	4896826.0
2012-08-22 12:30:00	SPY	ETF	141.33	141.7342	141.07	141.11	4922087.0
2012-08-22 13:00:00	SPY	ETF	141.11	141.7342	141.08	141.3	13995173.0
2012-08-22 13:30:00	SPY	ETF	141.3	141.41	141.18	141.26	3338751.0
2012-08-22 14:00:00	SPY	ETF	141.26	141.78	141.26	141.48	15347610.0
2012-08-22 14:30:00	SPY	ETF	141.48	141.99	141.42	141.94	9100095.0
2012-08-22 15:00:00	SPY	ETF	141.95	142.05	141.72	141.8	6471730.0
2012-08-22 15:30:00	SPY	ETF	141.8	141.93	141.71	141.79	12575735.0
2012-08-22 16:00:00	SPY	ETF	141.8	141.93	141.1649	141.86	14807165.0
2012-08-22 16:30:00	SPY	ETF	141.86	141.88	141.77	141.87	567437.0
2012-08-22 17:00:00	SPY	ETF	141.87	141.93	141.82	141.83	39234.0
2012-08-22 17:30:00	SPY	ETF	141.85	141.87	141.83	141.85	37304.0
2012-08-22 18:00:00	SPY	ETF	141.85	141.85	141.79	141.84	52101.0
2012-08-22 18:30:00	SPY	ETF	141.82	141.87	141.81	141.85	97400.0
2012-08-22 19:00:00	SPY	ETF	141.85	141.89	141.82	141.84	5450.0
2012-08-22 19:30:00	SPY	ETF	141.84	141.96	141.84	141.96	140440.0
2012-08-22 05:00:00	QQQ	ETF	68.07	68.07	68.07	68.07	300.0
2012-08-22 06:00:00	QQQ	ETF	68.09	68.09	68.09	68.09	100.0
2012-08-22 06:30:00	QQQ	ETF	68.09	68.09	68.09	68.09	400.0
2012-08-22 07:00:00	QQQ	ETF	67.99	68.0	67.96	67.96	9950.0
2012-08-22 07:30:00	QQQ	ETF	67.98	68.0	67.98	67.99	12500.0
2012-08-22 08:00:00	QQQ	ETF	68.02	68.09	68.01	68.08	83643.0
2012-08-22 08:30:00	QQQ	ETF	68.08	68.11	67.97	68.03	109140.0
2012-08-22 09:00:00	QQQ	ETF	68.04	68.06	67.92	67.96	249307.0
2012-08-22 09:30:00	QQQ	ETF	67.97	68.16	67.81	68.13	6934286.0
2012-08-22 10:00:00	QQQ	ETF	68.14	68.24	67.99	68.19	2624947.0
2012-08-22 10:30:00	QQQ	ETF	68.2	68.24	68.02	68.06	1478040.0
2012-08-22 11:00:00	QQQ	ETF	68.06	68.17	67.99	68.06	1931533.0
2012-08-22 11:30:00	QQQ	ETF	68.06	68.16	67.99	68.158	1776137.0
2012-08-22 12:00:00	QQQ	ETF	68.155	68.19	68.03	68.11	1707386.0
2012-08-22 12:30:00	QQQ	ETF	68.12	68.12	67.94	67.97	957435.0
2012-08-22 13:00:00	QQQ	ETF	67.96	68.13	67.94	68.1	609854.0
2012-08-22 13:30:00	QQQ	ETF	68.1	68.19	68.0401	68.07	1189604.0
2012-08-22 14:00:00	QQQ	ETF	68.08	68.35	68.06	68.21	4273449.0

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

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