PREVIEW / etf_30min / 2012-04-18

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-18.parquet
  size:    270 KB
  rows:    9,241

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-04-18 04:00:00	SPY	ETF	138.97	139.1	138.97	139.1	15550.0
2012-04-18 04:30:00	SPY	ETF	138.91	138.91	138.8	138.8	268.0
2012-04-18 05:00:00	SPY	ETF	138.73	138.86	138.7	138.83	1400.0
2012-04-18 05:30:00	SPY	ETF	138.85	138.86	138.74	138.8	6500.0
2012-04-18 06:00:00	SPY	ETF	138.77	138.78	138.76	138.78	3732.0
2012-04-18 06:30:00	SPY	ETF	138.7	138.72	138.49	138.49	54660.0
2012-04-18 07:00:00	SPY	ETF	138.53	138.55	138.4	138.53	300780.0
2012-04-18 07:30:00	SPY	ETF	138.47	138.59	138.34	138.54	219205.0
2012-04-18 08:00:00	SPY	ETF	138.55	138.71	138.47	138.54	391989.0
2012-04-18 08:30:00	SPY	ETF	138.54	138.6	138.29	138.44	1046411.0
2012-04-18 09:00:00	SPY	ETF	138.43	138.57	138.39	138.46	947560.0
2012-04-18 09:30:00	SPY	ETF	138.46	138.9	138.38	138.86	15694395.0
2012-04-18 10:00:00	SPY	ETF	138.86	138.98	138.69	138.72	16005251.0
2012-04-18 10:30:00	SPY	ETF	138.72	139.06	138.65	138.945	10615839.0
2012-04-18 11:00:00	SPY	ETF	138.945	138.98	138.48	138.59	13476545.0
2012-04-18 11:30:00	SPY	ETF	138.59	138.85	138.42	138.77	9513239.0
2012-04-18 12:00:00	SPY	ETF	138.765	138.8	138.59	138.63	3793539.0
2012-04-18 12:30:00	SPY	ETF	138.63	138.73	138.59	138.6789	3662539.0
2012-04-18 13:00:00	SPY	ETF	138.67	138.79	138.61	138.62	3302310.0
2012-04-18 13:30:00	SPY	ETF	138.62	138.68	138.38	138.44	4232196.0
2012-04-18 14:00:00	SPY	ETF	138.44	138.91	138.39	138.8005	6320020.0
2012-04-18 14:30:00	SPY	ETF	138.81	138.9	138.78	138.87	4171159.0
2012-04-18 15:00:00	SPY	ETF	138.88	139.08	138.69	138.73	8803738.0
2012-04-18 15:30:00	SPY	ETF	138.73	138.83	138.55	138.62	12883641.0
2012-04-18 16:00:00	SPY	ETF	138.62	138.8637	138.3	138.38	4837656.0
2012-04-18 16:30:00	SPY	ETF	138.39	138.49	138.35	138.49	1491502.0
2012-04-18 17:00:00	SPY	ETF	138.5	138.55	138.46	138.5	106863.0
2012-04-18 17:30:00	SPY	ETF	138.5	138.54	138.45	138.52	55998.0
2012-04-18 18:00:00	SPY	ETF	138.52	138.52	138.46	138.47	21929.0
2012-04-18 18:30:00	SPY	ETF	138.47	138.49	138.45	138.49	8142.0
2012-04-18 19:00:00	SPY	ETF	138.48	138.52	138.45	138.45	37064.0
2012-04-18 19:30:00	SPY	ETF	138.44	138.53	138.42	138.47	72413.0
2012-04-18 06:30:00	QQQ	ETF	66.51	66.51	66.5	66.5	4600.0
2012-04-18 07:00:00	QQQ	ETF	66.48	66.49	66.4	66.45	58000.0
2012-04-18 07:30:00	QQQ	ETF	66.41	66.5	66.36	66.49	93710.0
2012-04-18 08:00:00	QQQ	ETF	66.49	66.63	66.46	66.55	158525.0
2012-04-18 08:30:00	QQQ	ETF	66.55	66.56	66.45	66.55	290155.0
2012-04-18 09:00:00	QQQ	ETF	66.54	66.6	66.5	66.58	149022.0
2012-04-18 09:30:00	QQQ	ETF	66.59	66.86	66.51	66.8577	5981247.0
2012-04-18 10:00:00	QQQ	ETF	66.85	66.92	66.71	66.8	4315527.0
2012-04-18 10:30:00	QQQ	ETF	66.81	66.92	66.685	66.85	3166577.0
2012-04-18 11:00:00	QQQ	ETF	66.85	66.87	66.45	66.54	4708297.0
2012-04-18 11:30:00	QQQ	ETF	66.55	66.7	66.41	66.65	2569188.0
2012-04-18 12:00:00	QQQ	ETF	66.65	66.68	66.52	66.54	1360125.0
2012-04-18 12:30:00	QQQ	ETF	66.54	66.66	66.52	66.62	1011449.0
2012-04-18 13:00:00	QQQ	ETF	66.62	66.6999	66.565	66.57	1571190.0
2012-04-18 13:30:00	QQQ	ETF	66.572	66.6	66.46	66.49	1341076.0
2012-04-18 14:00:00	QQQ	ETF	66.49	66.9	66.46	66.83	2210892.0
2012-04-18 14:30:00	QQQ	ETF	66.83	66.91	66.82	66.895	1254544.0
2012-04-18 15:00:00	QQQ	ETF	66.89	67.0	66.7101	66.73	3019262.0

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

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