PREVIEW / etf_30min / 2013-01-14

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-14.parquet
  size:    290 KB
  rows:    10,171

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
2013-01-14 04:00:00	SPY	ETF	147.23	147.37	147.23	147.37	63306.0
2013-01-14 04:30:00	SPY	ETF	147.45	147.45	147.3	147.3	45208.0
2013-01-14 05:00:00	SPY	ETF	147.38	147.44	147.36	147.41	25500.0
2013-01-14 05:30:00	SPY	ETF	147.28	147.28	147.22	147.22	9100.0
2013-01-14 06:00:00	SPY	ETF	147.22	147.22	147.14	147.14	34930.0
2013-01-14 06:30:00	SPY	ETF	147.18	147.22	147.14	147.18	115700.0
2013-01-14 07:00:00	SPY	ETF	147.19	147.22	146.98	146.98	252496.0
2013-01-14 07:30:00	SPY	ETF	146.99	147.04	146.88	146.89	211167.0
2013-01-14 08:00:00	SPY	ETF	146.92	147.2	146.82	147.0	932119.0
2013-01-14 08:30:00	SPY	ETF	147.0	147.05	146.97	146.98	954710.0
2013-01-14 09:00:00	SPY	ETF	147.0	147.07	146.85	146.89	681427.0
2013-01-14 09:30:00	SPY	ETF	146.89	147.07	146.56	146.661	16711287.0
2013-01-14 10:00:00	SPY	ETF	146.66	146.695	146.43	146.52	9480955.0
2013-01-14 10:30:00	SPY	ETF	146.52	146.79	146.512	146.73	6807629.0
2013-01-14 11:00:00	SPY	ETF	146.73	146.85	146.72	146.76	3138207.0
2013-01-14 11:30:00	SPY	ETF	146.77	146.82	146.59	146.79	4346839.0
2013-01-14 12:00:00	SPY	ETF	146.79	146.85	146.61	146.64	4905068.0
2013-01-14 12:30:00	SPY	ETF	146.63	146.78	146.62	146.69	2264024.0
2013-01-14 13:00:00	SPY	ETF	146.69	146.85	146.57	146.8	3341457.0
2013-01-14 13:30:00	SPY	ETF	146.8	146.81	146.66	146.72	2140278.0
2013-01-14 14:00:00	SPY	ETF	146.712	146.95	146.66	146.919	5983010.0
2013-01-14 14:30:00	SPY	ETF	146.9101	147.01	146.85	146.9	3040038.0
2013-01-14 15:00:00	SPY	ETF	146.91	147.0684	146.89	146.92	4685946.0
2013-01-14 15:30:00	SPY	ETF	146.925	146.97	146.67	146.96	10186706.0
2013-01-14 16:00:00	SPY	ETF	146.96	147.02	146.71	146.76	3227962.0
2013-01-14 16:30:00	SPY	ETF	146.76	146.97	146.5954	146.93	2675869.0
2013-01-14 17:00:00	SPY	ETF	146.86	146.88	146.85	146.86	104308.0
2013-01-14 17:30:00	SPY	ETF	146.87	146.89	146.85	146.88	27130.0
2013-01-14 18:00:00	SPY	ETF	146.86	146.9	146.83	146.89	8600.0
2013-01-14 18:30:00	SPY	ETF	146.9	146.9	146.86	146.86	24650.0
2013-01-14 19:00:00	SPY	ETF	146.88	146.9	146.81	146.9	29637.0
2013-01-14 19:30:00	SPY	ETF	146.89	146.89	146.78	146.79	9087.0
2013-01-14 04:00:00	QQQ	ETF	67.3	67.31	67.2	67.2	3200.0
2013-01-14 05:30:00	QQQ	ETF	67.16	67.16	67.06	67.06	5000.0
2013-01-14 06:00:00	QQQ	ETF	67.07	67.07	67.0	67.0	18298.0
2013-01-14 06:30:00	QQQ	ETF	66.96	67.07	66.96	67.04	6900.0
2013-01-14 07:00:00	QQQ	ETF	67.01	67.02	67.0	67.0	41600.0
2013-01-14 07:30:00	QQQ	ETF	66.96	66.99	66.88	66.88	50000.0
2013-01-14 08:00:00	QQQ	ETF	66.89	67.06	66.85	66.99	70439.0
2013-01-14 08:30:00	QQQ	ETF	66.98	67.0	66.94	66.94	170951.0
2013-01-14 09:00:00	QQQ	ETF	66.94	66.94	66.87	66.9	178635.0
2013-01-14 09:30:00	QQQ	ETF	66.9	67.15	66.79	66.84	9160529.0
2013-01-14 10:00:00	QQQ	ETF	66.83	66.85	66.67	66.7241	2775863.0
2013-01-14 10:30:00	QQQ	ETF	66.73	66.87	66.72	66.8322	4603512.0
2013-01-14 11:00:00	QQQ	ETF	66.8399	66.9	66.79	66.83	1380201.0
2013-01-14 11:30:00	QQQ	ETF	66.83	66.88	66.75	66.84	1869385.0
2013-01-14 12:00:00	QQQ	ETF	66.85	66.865	66.7399	66.76	864526.0
2013-01-14 12:30:00	QQQ	ETF	66.77	66.85	66.77	66.79	695049.0
2013-01-14 13:00:00	QQQ	ETF	66.79	66.86	66.7	66.85	858720.0
2013-01-14 13:30:00	QQQ	ETF	66.85	66.86	66.74	66.77	422082.0

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

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