PREVIEW / etf_30min / 2012-09-14

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-14.parquet
  size:    314 KB
  rows:    10,717

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-09-14 04:00:00	SPY	ETF	146.8	146.8	146.65	146.65	1300.0
2012-09-14 04:30:00	SPY	ETF	146.77	146.78	146.77	146.78	400.0
2012-09-14 05:00:00	SPY	ETF	146.78	146.9	146.77	146.9	25650.0
2012-09-14 05:30:00	SPY	ETF	146.9	147.0	146.9	146.99	69200.0
2012-09-14 06:00:00	SPY	ETF	146.95	147.12	146.95	147.01	42920.0
2012-09-14 06:30:00	SPY	ETF	147.02	147.13	147.01	147.12	36645.0
2012-09-14 07:00:00	SPY	ETF	147.11	147.17	147.05	147.09	134442.0
2012-09-14 07:30:00	SPY	ETF	147.08	147.11	146.91	146.93	197519.0
2012-09-14 08:00:00	SPY	ETF	146.95	147.12	146.86	146.99	1297333.0
2012-09-14 08:30:00	SPY	ETF	147.16	147.17	146.68	146.78	933705.0
2012-09-14 09:00:00	SPY	ETF	146.77	146.89	146.65	146.87	1530670.0
2012-09-14 09:30:00	SPY	ETF	146.88	147.66	146.83	147.38	23922710.0
2012-09-14 10:00:00	SPY	ETF	147.38	148.11	147.37	147.86	18795658.0
2012-09-14 10:30:00	SPY	ETF	147.87	147.89	147.38	147.49	12448605.0
2012-09-14 11:00:00	SPY	ETF	147.48	147.58	147.3	147.53	14430010.0
2012-09-14 11:30:00	SPY	ETF	147.54	147.58	147.16	147.26	9564846.0
2012-09-14 12:00:00	SPY	ETF	147.26	147.65	147.24	147.59	7266809.0
2012-09-14 12:30:00	SPY	ETF	147.59	147.61	147.39	147.41	4495937.0
2012-09-14 13:00:00	SPY	ETF	147.4	147.44	146.95	146.99	5679883.0
2012-09-14 13:30:00	SPY	ETF	146.98	147.28	146.97	147.246	5128376.0
2012-09-14 14:00:00	SPY	ETF	147.25	147.32	147.12	147.24	8182480.0
2012-09-14 14:30:00	SPY	ETF	147.245	147.37	147.09	147.3	6447579.0
2012-09-14 15:00:00	SPY	ETF	147.3	147.32	146.78	146.97	10046754.0
2012-09-14 15:30:00	SPY	ETF	146.97	147.24	146.76	147.2	24266312.0
2012-09-14 16:00:00	SPY	ETF	147.22	148.0	146.6244	147.1	10196894.0
2012-09-14 16:30:00	SPY	ETF	147.1	147.12	147.01	147.05	1668245.0
2012-09-14 17:00:00	SPY	ETF	147.05	147.07	146.96	147.0	1428439.0
2012-09-14 17:30:00	SPY	ETF	146.97	147.0	146.86	146.93	165358.0
2012-09-14 18:00:00	SPY	ETF	146.94	146.97	146.9	146.96	54699.0
2012-09-14 18:30:00	SPY	ETF	146.94	146.99	146.9	146.95	24119.0
2012-09-14 19:00:00	SPY	ETF	146.92	146.99	146.92	146.95	13390.0
2012-09-14 19:30:00	SPY	ETF	146.98	147.03	146.95	146.97	11785.0
2012-09-14 05:00:00	QQQ	ETF	69.78	69.78	69.78	69.78	100.0
2012-09-14 06:00:00	QQQ	ETF	69.88	69.88	69.88	69.88	100.0
2012-09-14 06:30:00	QQQ	ETF	69.89	69.89	69.89	69.89	300.0
2012-09-14 07:00:00	QQQ	ETF	69.9	69.91	69.86	69.86	16320.0
2012-09-14 07:30:00	QQQ	ETF	69.88	69.89	69.83	69.83	27595.0
2012-09-14 08:00:00	QQQ	ETF	69.84	69.89	69.8	69.84	82282.0
2012-09-14 08:30:00	QQQ	ETF	69.81	69.89	69.7	69.72	243789.0
2012-09-14 09:00:00	QQQ	ETF	69.71	69.84	69.58	69.84	492614.0
2012-09-14 09:30:00	QQQ	ETF	69.84	70.23	69.79	70.12	8650974.0
2012-09-14 10:00:00	QQQ	ETF	70.12	70.43	70.1	70.3099	5287589.0
2012-09-14 10:30:00	QQQ	ETF	70.3	70.33	70.18	70.27	2846869.0
2012-09-14 11:00:00	QQQ	ETF	70.26	70.32	70.17	70.31	2167481.0
2012-09-14 11:30:00	QQQ	ETF	70.3001	70.35	70.1923	70.24	1594328.0
2012-09-14 12:00:00	QQQ	ETF	70.24	70.42	70.21	70.4	1024704.0
2012-09-14 12:30:00	QQQ	ETF	70.4008	70.43	70.35	70.36	696540.0
2012-09-14 13:00:00	QQQ	ETF	70.36	70.38	70.14	70.15	1472795.0
2012-09-14 13:30:00	QQQ	ETF	70.15	70.24	70.12	70.1966	1990277.0
2012-09-14 14:00:00	QQQ	ETF	70.2	70.27	70.14	70.228	1133193.0

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

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