PREVIEW / etf_30min / 2013-03-26

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-26.parquet
  size:    299 KB
  rows:    10,178

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-03-26 04:00:00	SPY	ETF	155.28	155.44	155.25	155.4	22871.0
2013-03-26 04:30:00	SPY	ETF	155.39	155.46	155.3	155.42	23200.0
2013-03-26 05:00:00	SPY	ETF	155.44	155.45	155.36	155.4	2784.0
2013-03-26 05:30:00	SPY	ETF	155.42	155.5	155.4	155.49	16495.0
2013-03-26 06:00:00	SPY	ETF	155.49	155.54	155.44	155.47	40200.0
2013-03-26 06:30:00	SPY	ETF	155.49	155.5	155.46	155.5	27700.0
2013-03-26 07:00:00	SPY	ETF	155.5	155.54	155.36	155.37	187024.0
2013-03-26 07:30:00	SPY	ETF	155.35	155.44	155.21	155.22	200973.0
2013-03-26 08:00:00	SPY	ETF	155.22	155.51	155.2	155.5	1820151.0
2013-03-26 08:30:00	SPY	ETF	155.5	155.51	155.31	155.43	439190.0
2013-03-26 09:00:00	SPY	ETF	155.43	155.64	155.34	155.58	960212.0
2013-03-26 09:30:00	SPY	ETF	155.59	155.93	155.5501	155.83	11827307.0
2013-03-26 10:00:00	SPY	ETF	155.8	155.99	155.6	155.86	10311057.0
2013-03-26 10:30:00	SPY	ETF	155.86	156.01	155.42	155.74	10877540.0
2013-03-26 11:00:00	SPY	ETF	155.73	155.84	155.58	155.66	4448702.0
2013-03-26 11:30:00	SPY	ETF	155.66	155.91	155.66	155.7101	3488628.0
2013-03-26 12:00:00	SPY	ETF	155.72	155.85	155.54	155.68	3701063.0
2013-03-26 12:30:00	SPY	ETF	155.68	155.75	155.62	155.68	2899708.0
2013-03-26 13:00:00	SPY	ETF	155.68	155.9	155.6399	155.86	3593804.0
2013-03-26 13:30:00	SPY	ETF	155.86	155.95	155.801	155.905	3005020.0
2013-03-26 14:00:00	SPY	ETF	155.9099	156.04	155.86	155.951	3322723.0
2013-03-26 14:30:00	SPY	ETF	155.955	155.99	155.84	155.9199	2453582.0
2013-03-26 15:00:00	SPY	ETF	155.92	156.14	155.91	156.07	5204186.0
2013-03-26 15:30:00	SPY	ETF	156.06	156.23	156.02	156.14	11829763.0
2013-03-26 16:00:00	SPY	ETF	156.15	156.27	156.08	156.13	3405879.0
2013-03-26 16:30:00	SPY	ETF	156.13	156.2	156.06	156.19	277170.0
2013-03-26 17:00:00	SPY	ETF	156.19	156.23	156.17	156.2	166450.0
2013-03-26 17:30:00	SPY	ETF	156.2	156.23	156.16	156.23	36763.0
2013-03-26 18:00:00	SPY	ETF	156.19	156.19	156.15	156.15	43062.0
2013-03-26 18:30:00	SPY	ETF	156.17	156.26	156.15	156.26	51148.0
2013-03-26 19:00:00	SPY	ETF	156.24	156.26	156.21	156.22	20814.0
2013-03-26 19:30:00	SPY	ETF	156.21	156.22	156.16	156.17	17370.0
2013-03-26 04:00:00	QQQ	ETF	68.55	68.56	68.48	68.51	10400.0
2013-03-26 04:30:00	QQQ	ETF	68.56	68.56	68.56	68.56	200.0
2013-03-26 05:30:00	QQQ	ETF	68.5	68.5	68.5	68.5	100.0
2013-03-26 06:00:00	QQQ	ETF	68.57	68.57	68.57	68.57	200.0
2013-03-26 06:30:00	QQQ	ETF	68.55	68.55	68.55	68.55	8200.0
2013-03-26 07:00:00	QQQ	ETF	68.55	68.55	68.5	68.5	12600.0
2013-03-26 07:30:00	QQQ	ETF	68.49	68.52	68.43	68.43	1550.0
2013-03-26 08:00:00	QQQ	ETF	68.43	68.52	68.43	68.44	1602874.0
2013-03-26 08:30:00	QQQ	ETF	68.48	68.51	68.45	68.51	7283.0
2013-03-26 09:00:00	QQQ	ETF	68.51	68.62	68.46	68.61	45495.0
2013-03-26 09:30:00	QQQ	ETF	68.61	68.72	68.57	68.62	2293538.0
2013-03-26 10:00:00	QQQ	ETF	68.63	68.71	68.54	68.6	2467778.0
2013-03-26 10:30:00	QQQ	ETF	68.61	68.669	68.45	68.57	1921870.0
2013-03-26 11:00:00	QQQ	ETF	68.57	68.62	68.5	68.537	764609.0
2013-03-26 11:30:00	QQQ	ETF	68.5337	68.67	68.5337	68.56	535130.0
2013-03-26 12:00:00	QQQ	ETF	68.56	68.61	68.45	68.53	788407.0
2013-03-26 12:30:00	QQQ	ETF	68.53	68.55	68.49	68.51	679765.0
2013-03-26 13:00:00	QQQ	ETF	68.51	68.65	68.51	68.64	572578.0

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

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