PREVIEW / etf_30min / 2013-01-15

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-01-15.parquet
  size:    303 KB
  rows:    10,250

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-15 04:00:00	SPY	ETF	146.55	146.6	146.55	146.55	2000.0
2013-01-15 04:30:00	SPY	ETF	146.64	146.64	146.64	146.64	100.0
2013-01-15 05:00:00	SPY	ETF	146.7	146.7	146.62	146.62	4200.0
2013-01-15 05:30:00	SPY	ETF	146.65	146.65	146.54	146.54	8606.0
2013-01-15 06:00:00	SPY	ETF	146.6	146.6	146.49	146.49	12183.0
2013-01-15 06:30:00	SPY	ETF	146.51	146.51	146.41	146.43	58292.0
2013-01-15 07:00:00	SPY	ETF	146.45	146.45	146.26	146.35	235722.0
2013-01-15 07:30:00	SPY	ETF	146.35	146.35	146.11	146.24	303197.0
2013-01-15 08:00:00	SPY	ETF	146.24	146.33	146.06	146.08	337722.0
2013-01-15 08:30:00	SPY	ETF	146.09	146.39	146.02	146.24	764067.0
2013-01-15 09:00:00	SPY	ETF	146.23	146.36	146.23	146.29	445635.0
2013-01-15 09:30:00	SPY	ETF	146.29	146.5	146.2	146.46	12833365.0
2013-01-15 10:00:00	SPY	ETF	146.45	146.9315	146.36	146.4	9228363.0
2013-01-15 10:30:00	SPY	ETF	146.4	146.67	146.37	146.62	4471740.0
2013-01-15 11:00:00	SPY	ETF	146.62	146.69	146.49	146.6	4004468.0
2013-01-15 11:30:00	SPY	ETF	146.6	146.75	146.59	146.635	3989510.0
2013-01-15 12:00:00	SPY	ETF	146.63	146.8	146.63	146.745	2990999.0
2013-01-15 12:30:00	SPY	ETF	146.75	146.93	146.74	146.805	3803893.0
2013-01-15 13:00:00	SPY	ETF	146.8	146.92	146.79	146.84	4085085.0
2013-01-15 13:30:00	SPY	ETF	146.84	146.9315	146.59	146.65	4712961.0
2013-01-15 14:00:00	SPY	ETF	146.65	146.75	146.61	146.6324	3853904.0
2013-01-15 14:30:00	SPY	ETF	146.635	146.95	146.635	146.93	4457143.0
2013-01-15 15:00:00	SPY	ETF	146.93	147.11	146.925	147.041	6255780.0
2013-01-15 15:30:00	SPY	ETF	147.05	147.21	147.01	147.04	12298892.0
2013-01-15 16:00:00	SPY	ETF	147.04	147.0879	146.35	146.94	7370513.0
2013-01-15 16:30:00	SPY	ETF	146.94	147.07	146.93	147.03	3270166.0
2013-01-15 17:00:00	SPY	ETF	147.02	147.1	146.84	147.05	144057.0
2013-01-15 17:30:00	SPY	ETF	147.05	147.08	147.05	147.08	18695.0
2013-01-15 18:00:00	SPY	ETF	147.02	147.12	147.02	147.09	13254.0
2013-01-15 18:30:00	SPY	ETF	147.06	147.1	147.06	147.1	13349.0
2013-01-15 19:00:00	SPY	ETF	147.07	147.09	147.06	147.08	7100.0
2013-01-15 19:30:00	SPY	ETF	147.1	147.1	147.07	147.07	9361.0
2013-01-15 05:30:00	QQQ	ETF	66.85	66.86	66.85	66.86	2955.0
2013-01-15 06:00:00	QQQ	ETF	66.83	66.83	66.81	66.81	76950.0
2013-01-15 06:30:00	QQQ	ETF	66.79	66.79	66.79	66.79	2500.0
2013-01-15 07:00:00	QQQ	ETF	66.75	66.76	66.71	66.75	12650.0
2013-01-15 07:30:00	QQQ	ETF	66.73	66.73	66.68	66.72	30710.0
2013-01-15 08:00:00	QQQ	ETF	66.77	66.77	66.66	66.66	32770.0
2013-01-15 08:30:00	QQQ	ETF	66.73	66.95	66.65	66.68	23015.0
2013-01-15 09:00:00	QQQ	ETF	66.69	66.71	66.58	66.64	112943.0
2013-01-15 09:30:00	QQQ	ETF	66.64	66.67	66.3321	66.45	4932728.0
2013-01-15 10:00:00	QQQ	ETF	66.45	66.51	66.38	66.41	1870116.0
2013-01-15 10:30:00	QQQ	ETF	66.4	66.51	66.39	66.49	1287775.0
2013-01-15 11:00:00	QQQ	ETF	66.5	66.54	66.44	66.46	1497656.0
2013-01-15 11:30:00	QQQ	ETF	66.4685	66.57	66.4594	66.46	1344621.0
2013-01-15 12:00:00	QQQ	ETF	66.46	66.61	66.455	66.5777	1213587.0
2013-01-15 12:30:00	QQQ	ETF	66.58	66.729	66.57	66.62	1319042.0
2013-01-15 13:00:00	QQQ	ETF	66.62	66.72	66.59	66.631	915154.0
2013-01-15 13:30:00	QQQ	ETF	66.63	66.67	66.49	66.52	1983308.0
2013-01-15 14:00:00	QQQ	ETF	66.53	66.55	66.425	66.43	1193930.0

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

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