PREVIEW / etf_30min / 2012-06-12

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-12.parquet
  size:    283 KB
  rows:    9,457

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-12 04:00:00	SPY	ETF	131.61	131.77	131.52	131.66	4130.0
2012-06-12 04:30:00	SPY	ETF	131.79	132.09	131.76	132.09	4200.0
2012-06-12 05:00:00	SPY	ETF	132.09	132.09	131.82	131.85	29610.0
2012-06-12 05:30:00	SPY	ETF	131.9	131.97	131.66	131.92	7500.0
2012-06-12 06:00:00	SPY	ETF	131.92	132.12	131.92	132.04	19325.0
2012-06-12 06:30:00	SPY	ETF	132.06	132.11	131.84	131.89	154950.0
2012-06-12 07:00:00	SPY	ETF	131.9	131.9	131.69	131.71	289380.0
2012-06-12 07:30:00	SPY	ETF	131.67	131.83	131.62	131.67	197864.0
2012-06-12 08:00:00	SPY	ETF	131.67	132.09	131.46	131.81	1086583.0
2012-06-12 08:30:00	SPY	ETF	131.77	131.9	131.45	131.68	939625.0
2012-06-12 09:00:00	SPY	ETF	131.69	132.1	131.45	131.78	4000626.0
2012-06-12 09:30:00	SPY	ETF	131.79	132.01	131.48	131.79	23415801.0
2012-06-12 10:00:00	SPY	ETF	131.79	132.13	131.27	131.44	23801832.0
2012-06-12 10:30:00	SPY	ETF	131.4301	131.8	131.16	131.65	14399495.0
2012-06-12 11:00:00	SPY	ETF	131.65	132.64	131.64	132.48	19354877.0
2012-06-12 11:30:00	SPY	ETF	132.49	132.56	132.17	132.24	9543659.0
2012-06-12 12:00:00	SPY	ETF	132.23	132.38	132.06	132.16	6939026.0
2012-06-12 12:30:00	SPY	ETF	132.16	132.32	131.98	132.059	4634330.0
2012-06-12 13:00:00	SPY	ETF	132.06	132.46	131.98	132.23	8498964.0
2012-06-12 13:30:00	SPY	ETF	132.23	132.45	132.12	132.19	6158967.0
2012-06-12 14:00:00	SPY	ETF	132.19	132.32	132.07	132.2	6317737.0
2012-06-12 14:30:00	SPY	ETF	132.21	132.6	132.205	132.43	7697474.0
2012-06-12 15:00:00	SPY	ETF	132.43	132.67	132.29	132.63	7606319.0
2012-06-12 15:30:00	SPY	ETF	132.63	132.99	132.46	132.95	19878495.0
2012-06-12 16:00:00	SPY	ETF	132.94	133.28	132.92	133.16	11585923.0
2012-06-12 16:30:00	SPY	ETF	133.2	133.21	131.4246	133.09	1125859.0
2012-06-12 17:00:00	SPY	ETF	133.09	133.12	133.05	133.07	154916.0
2012-06-12 17:30:00	SPY	ETF	133.07	133.13	133.04	133.07	83589.0
2012-06-12 18:00:00	SPY	ETF	133.09	133.1	133.03	133.03	26315.0
2012-06-12 18:30:00	SPY	ETF	133.04	133.08	133.04	133.07	3484.0
2012-06-12 19:00:00	SPY	ETF	133.06	133.07	133.01	133.05	9964.0
2012-06-12 19:30:00	SPY	ETF	133.03	133.14	133.01	133.01	116659.0
2012-06-12 04:00:00	QQQ	ETF	61.95	61.95	61.93	61.93	400.0
2012-06-12 04:30:00	QQQ	ETF	62.15	62.15	62.15	62.15	100.0
2012-06-12 05:00:00	QQQ	ETF	62.22	62.22	62.22	62.22	100.0
2012-06-12 06:00:00	QQQ	ETF	62.21	62.24	62.21	62.24	600.0
2012-06-12 06:30:00	QQQ	ETF	62.23	62.24	62.16	62.18	3300.0
2012-06-12 07:00:00	QQQ	ETF	62.15	62.15	62.05	62.05	18800.0
2012-06-12 07:30:00	QQQ	ETF	62.03	62.14	62.02	62.03	18615.0
2012-06-12 08:00:00	QQQ	ETF	62.03	62.11	61.93	62.07	38515.0
2012-06-12 08:30:00	QQQ	ETF	62.07	62.12	61.99	62.06	184239.0
2012-06-12 09:00:00	QQQ	ETF	62.07	62.27	62.07	62.09	1378870.0
2012-06-12 09:30:00	QQQ	ETF	62.09	62.27	61.9818	62.08	7240642.0
2012-06-12 10:00:00	QQQ	ETF	62.09	62.18	61.7	61.85	7025845.0
2012-06-12 10:30:00	QQQ	ETF	61.84	62.0	61.68	61.93	3202617.0
2012-06-12 11:00:00	QQQ	ETF	61.93	62.49	61.9289	62.425	4600449.0
2012-06-12 11:30:00	QQQ	ETF	62.43	62.49	62.28	62.33	1649611.0
2012-06-12 12:00:00	QQQ	ETF	62.33	62.4401	62.23	62.285	1862275.0
2012-06-12 12:30:00	QQQ	ETF	62.27	62.35	62.1	62.15	1782436.0
2012-06-12 13:00:00	QQQ	ETF	62.15	62.33	62.11	62.2	1530477.0

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

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