PREVIEW / etf_30min / 2013-03-22

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-22.parquet
  size:    296 KB
  rows:    10,076

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-22 04:00:00	SPY	ETF	154.27	154.27	154.12	154.17	1400.0
2013-03-22 04:30:00	SPY	ETF	154.24	154.31	154.24	154.31	800.0
2013-03-22 05:00:00	SPY	ETF	154.15	154.36	154.15	154.35	6400.0
2013-03-22 05:30:00	SPY	ETF	154.3	154.36	154.3	154.35	1828.0
2013-03-22 06:00:00	SPY	ETF	154.33	154.41	154.33	154.35	42423.0
2013-03-22 06:30:00	SPY	ETF	154.34	154.47	154.3	154.47	61240.0
2013-03-22 07:00:00	SPY	ETF	154.45	154.78	154.44	154.71	396968.0
2013-03-22 07:30:00	SPY	ETF	154.69	154.8	154.68	154.7	214558.0
2013-03-22 08:00:00	SPY	ETF	154.67	154.7	154.65	154.66	166762.0
2013-03-22 08:30:00	SPY	ETF	154.66	154.79	154.61	154.68	274193.0
2013-03-22 09:00:00	SPY	ETF	154.69	154.87	154.64	154.85	980258.0
2013-03-22 09:30:00	SPY	ETF	154.85	155.03	154.73	154.94	13055473.0
2013-03-22 10:00:00	SPY	ETF	154.945	155.36	154.9401	155.289	12330668.0
2013-03-22 10:30:00	SPY	ETF	155.29	155.35	155.0	155.17	7349067.0
2013-03-22 11:00:00	SPY	ETF	155.17	155.45	155.13	155.4	7283855.0
2013-03-22 11:30:00	SPY	ETF	155.395	155.48	155.18	155.22	6041773.0
2013-03-22 12:00:00	SPY	ETF	155.2199	155.3	155.06	155.2	5876882.0
2013-03-22 12:30:00	SPY	ETF	155.2	155.27	155.11	155.26	4169936.0
2013-03-22 13:00:00	SPY	ETF	155.26	155.54	155.15	155.5	5166596.0
2013-03-22 13:30:00	SPY	ETF	155.5	155.57	155.2499	155.31	3954829.0
2013-03-22 14:00:00	SPY	ETF	155.3	155.39	155.22	155.35	3070080.0
2013-03-22 14:30:00	SPY	ETF	155.35	155.41	155.24	155.3	3118627.0
2013-03-22 15:00:00	SPY	ETF	155.31	155.32	155.05	155.12	5664408.0
2013-03-22 15:30:00	SPY	ETF	155.12	155.52	155.11	155.51	15787809.0
2013-03-22 16:00:00	SPY	ETF	155.52	155.71	155.34	155.67	5691777.0
2013-03-22 16:30:00	SPY	ETF	155.67	155.67	155.54	155.65	1066682.0
2013-03-22 17:00:00	SPY	ETF	155.66	155.79	154.48	155.7	96849.0
2013-03-22 17:30:00	SPY	ETF	155.71	155.85	155.67	155.83	77653.0
2013-03-22 18:00:00	SPY	ETF	155.83	155.89	155.71	155.73	50808.0
2013-03-22 18:30:00	SPY	ETF	155.76	155.8	155.73	155.75	6465.0
2013-03-22 19:00:00	SPY	ETF	155.77	155.83	155.75	155.8	6651.0
2013-03-22 19:30:00	SPY	ETF	155.8	155.85	155.76	155.84	17381.0
2013-03-22 04:00:00	QQQ	ETF	67.97	67.97	67.97	67.97	200.0
2013-03-22 06:30:00	QQQ	ETF	68.01	68.01	68.01	68.01	100.0
2013-03-22 07:00:00	QQQ	ETF	68.07	68.16	68.07	68.16	18400.0
2013-03-22 07:30:00	QQQ	ETF	68.15	68.17	68.14	68.14	9100.0
2013-03-22 08:00:00	QQQ	ETF	68.13	68.14	68.11	68.13	3290.0
2013-03-22 08:30:00	QQQ	ETF	68.12	68.17	68.11	68.15	14480.0
2013-03-22 09:00:00	QQQ	ETF	68.16	68.21	68.14	68.2	34069.0
2013-03-22 09:30:00	QQQ	ETF	68.21	68.29	68.13	68.215	4631221.0
2013-03-22 10:00:00	QQQ	ETF	68.2101	68.37	68.2101	68.3	2287169.0
2013-03-22 10:30:00	QQQ	ETF	68.3	68.375	68.13	68.29	1956339.0
2013-03-22 11:00:00	QQQ	ETF	68.29	68.395	68.25	68.36	1147611.0
2013-03-22 11:30:00	QQQ	ETF	68.37	68.39	68.28	68.31	1285134.0
2013-03-22 12:00:00	QQQ	ETF	68.31	68.39	68.29	68.3665	1236369.0
2013-03-22 12:30:00	QQQ	ETF	68.36	68.46	68.35	68.455	918962.0
2013-03-22 13:00:00	QQQ	ETF	68.46	68.62	68.43	68.609	1552568.0
2013-03-22 13:30:00	QQQ	ETF	68.6099	68.64	68.515	68.54	1090274.0
2013-03-22 14:00:00	QQQ	ETF	68.54	68.58	68.515	68.55	1094014.0
2013-03-22 14:30:00	QQQ	ETF	68.55	68.551	68.47	68.495	1461856.0

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

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