PREVIEW / etf_30min / 2012-06-06

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-06.parquet
  size:    297 KB
  rows:    9,904

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-06-06 04:00:00	SPY	ETF	130.0	130.38	130.0	130.31	6161.0
2012-06-06 04:30:00	SPY	ETF	130.36	130.58	130.3	130.51	3654.0
2012-06-06 05:00:00	SPY	ETF	130.43	130.51	130.33	130.46	20525.0
2012-06-06 05:30:00	SPY	ETF	130.48	130.5	130.28	130.28	31900.0
2012-06-06 06:00:00	SPY	ETF	130.26	130.51	130.16	130.46	56710.0
2012-06-06 06:30:00	SPY	ETF	130.51	130.6	130.43	130.49	375646.0
2012-06-06 07:00:00	SPY	ETF	130.46	130.67	130.43	130.52	694303.0
2012-06-06 07:30:00	SPY	ETF	130.57	130.62	130.15	130.34	1159794.0
2012-06-06 08:00:00	SPY	ETF	130.34	130.49	129.99	130.21	1352592.0
2012-06-06 08:30:00	SPY	ETF	130.19	130.39	129.03	129.7	4094046.0
2012-06-06 09:00:00	SPY	ETF	129.71	130.42	129.66	129.97	2890602.0
2012-06-06 09:30:00	SPY	ETF	129.97	130.79	129.93	130.6404	21977725.0
2012-06-06 10:00:00	SPY	ETF	130.6401	130.87	130.56	130.61	15234215.0
2012-06-06 10:30:00	SPY	ETF	130.6	131.03	130.57	130.99	11024158.0
2012-06-06 11:00:00	SPY	ETF	130.98	131.38	130.91	131.36	11022827.0
2012-06-06 11:30:00	SPY	ETF	131.36	131.44	131.19	131.3	9813902.0
2012-06-06 12:00:00	SPY	ETF	131.3	131.51	131.3	131.425	8712365.0
2012-06-06 12:30:00	SPY	ETF	131.425	131.64	131.38	131.5	6771112.0
2012-06-06 13:00:00	SPY	ETF	131.505	131.52	131.27	131.41	8402286.0
2012-06-06 13:30:00	SPY	ETF	131.4096	131.47	131.25	131.28	5251780.0
2012-06-06 14:00:00	SPY	ETF	131.28	131.43	131.08	131.31	10841795.0
2012-06-06 14:30:00	SPY	ETF	131.315	131.53	131.29	131.415	7829406.0
2012-06-06 15:00:00	SPY	ETF	131.412	131.55	131.26	131.34	10630878.0
2012-06-06 15:30:00	SPY	ETF	131.34	132.03	131.3	132.01	30477769.0
2012-06-06 16:00:00	SPY	ETF	132.01	132.17	130.9662	132.15	13168830.0
2012-06-06 16:30:00	SPY	ETF	132.15	132.19	132.05	132.08	570597.0
2012-06-06 17:00:00	SPY	ETF	132.09	132.19	132.08	132.18	206739.0
2012-06-06 17:30:00	SPY	ETF	132.13	132.18	132.08	132.13	149248.0
2012-06-06 18:00:00	SPY	ETF	132.15	132.33	132.13	132.27	100307.0
2012-06-06 18:30:00	SPY	ETF	132.27	132.41	132.25	132.31	107240.0
2012-06-06 19:00:00	SPY	ETF	132.31	132.32	132.23	132.24	26825.0
2012-06-06 19:30:00	SPY	ETF	132.23	132.4	132.2	132.3	127094.0
2012-06-06 04:00:00	QQQ	ETF	61.58	61.69	61.58	61.69	821.0
2012-06-06 05:30:00	QQQ	ETF	61.75	61.75	61.75	61.75	100.0
2012-06-06 06:00:00	QQQ	ETF	61.75	61.78	61.65	61.78	2966.0
2012-06-06 06:30:00	QQQ	ETF	61.8	61.84	61.8	61.84	72400.0
2012-06-06 07:00:00	QQQ	ETF	61.81	61.96	61.81	61.9	426491.0
2012-06-06 07:30:00	QQQ	ETF	61.91	61.91	61.72	61.79	52650.0
2012-06-06 08:00:00	QQQ	ETF	61.79	61.873	61.44	61.73	1019673.0
2012-06-06 08:30:00	QQQ	ETF	61.74	61.8	61.48	61.5	345628.0
2012-06-06 09:00:00	QQQ	ETF	61.52	61.65	61.52	61.6	167013.0
2012-06-06 09:30:00	QQQ	ETF	61.6	62.09	61.52	62.02	6893385.0
2012-06-06 10:00:00	QQQ	ETF	62.03	62.12	61.98	62.03	4552406.0
2012-06-06 10:30:00	QQQ	ETF	62.02	62.35	62.0	62.3005	14497357.0
2012-06-06 11:00:00	QQQ	ETF	62.31	62.37	62.215	62.37	3593776.0
2012-06-06 11:30:00	QQQ	ETF	62.36	62.42	62.29	62.345	2748304.0
2012-06-06 12:00:00	QQQ	ETF	62.335	62.43	62.329	62.39	1744078.0
2012-06-06 12:30:00	QQQ	ETF	62.38	62.5	62.37	62.44	1569709.0
2012-06-06 13:00:00	QQQ	ETF	62.4499	62.455	62.31	62.3899	2504556.0
2012-06-06 13:30:00	QQQ	ETF	62.38	62.4	62.28	62.29	1512542.0

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

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