PREVIEW / etf_30min / 2012-11-30

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-30.parquet
  size:    281 KB
  rows:    9,592

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-11-30 04:00:00	SPY	ETF	142.2	142.31	142.18	142.31	1050.0
2012-11-30 04:30:00	SPY	ETF	142.17	142.17	142.17	142.17	200.0
2012-11-30 05:00:00	SPY	ETF	142.15	142.34	142.15	142.34	6238.0
2012-11-30 05:30:00	SPY	ETF	142.36	142.36	142.31	142.34	3600.0
2012-11-30 06:00:00	SPY	ETF	142.31	142.4	142.31	142.4	52648.0
2012-11-30 06:30:00	SPY	ETF	142.39	142.59	142.39	142.42	105740.0
2012-11-30 07:00:00	SPY	ETF	142.42	142.53	142.41	142.44	108073.0
2012-11-30 07:30:00	SPY	ETF	142.44	142.45	142.31	142.35	44890.0
2012-11-30 08:00:00	SPY	ETF	142.33	142.43	142.2	142.31	557043.0
2012-11-30 08:30:00	SPY	ETF	142.31	142.36	142.1	142.21	424035.0
2012-11-30 09:00:00	SPY	ETF	142.2	142.23	142.11	142.14	410286.0
2012-11-30 09:30:00	SPY	ETF	142.14	142.25	141.91	142.07	14489984.0
2012-11-30 10:00:00	SPY	ETF	142.07	142.3	141.95	142.19	9712816.0
2012-11-30 10:30:00	SPY	ETF	142.19	142.22	141.78	142.02	8503916.0
2012-11-30 11:00:00	SPY	ETF	142.02	142.11	141.76	141.88	6880123.0
2012-11-30 11:30:00	SPY	ETF	141.86	141.945	141.66	141.825	8089669.0
2012-11-30 12:00:00	SPY	ETF	141.845	141.93	141.77	141.92	4731684.0
2012-11-30 12:30:00	SPY	ETF	141.91	142.01	141.69	141.825	9610844.0
2012-11-30 13:00:00	SPY	ETF	141.83	142.09	141.8	142.015	5508666.0
2012-11-30 13:30:00	SPY	ETF	142.01	142.0401	141.86	141.9699	4494186.0
2012-11-30 14:00:00	SPY	ETF	141.96	142.15	141.92	142.085	5401094.0
2012-11-30 14:30:00	SPY	ETF	142.08	142.1	141.76	141.771	5468895.0
2012-11-30 15:00:00	SPY	ETF	141.77	142.0	141.68	141.89	8571214.0
2012-11-30 15:30:00	SPY	ETF	141.88	142.42	141.85	142.059	21772844.0
2012-11-30 16:00:00	SPY	ETF	142.04	142.25	141.89	142.1	14091218.0
2012-11-30 16:30:00	SPY	ETF	142.09	142.18	141.9746	142.12	4964561.0
2012-11-30 17:00:00	SPY	ETF	142.13	142.27	141.9622	142.2	466305.0
2012-11-30 17:30:00	SPY	ETF	142.21	142.22	142.02	142.02	325373.0
2012-11-30 18:00:00	SPY	ETF	142.07	142.2	142.01	142.2	192746.0
2012-11-30 18:30:00	SPY	ETF	142.2	142.2	142.11	142.12	18003.0
2012-11-30 19:00:00	SPY	ETF	142.12	142.18	142.07	142.15	27650.0
2012-11-30 19:30:00	SPY	ETF	142.16	142.27	142.15	142.24	31262.0
2012-11-30 04:00:00	QQQ	ETF	66.07	66.07	66.05	66.05	386.0
2012-11-30 05:00:00	QQQ	ETF	66.03	66.03	66.03	66.03	100.0
2012-11-30 05:30:00	QQQ	ETF	66.05	66.05	66.05	66.05	600.0
2012-11-30 06:00:00	QQQ	ETF	66.08	66.08	66.08	66.08	100.0
2012-11-30 06:30:00	QQQ	ETF	66.13	66.13	66.13	66.13	400.0
2012-11-30 07:00:00	QQQ	ETF	66.11	66.12	66.07	66.07	1100.0
2012-11-30 07:30:00	QQQ	ETF	66.05	66.05	66.04	66.05	1700.0
2012-11-30 08:00:00	QQQ	ETF	66.06	66.07	65.95	65.97	139940.0
2012-11-30 08:30:00	QQQ	ETF	65.97	65.98	65.93	65.93	125941.0
2012-11-30 09:00:00	QQQ	ETF	65.93	65.94	65.86	65.92	142717.0
2012-11-30 09:30:00	QQQ	ETF	65.92	65.97	65.75	65.8	4429137.0
2012-11-30 10:00:00	QQQ	ETF	65.78	65.9	65.72	65.86	1988763.0
2012-11-30 10:30:00	QQQ	ETF	65.86	65.88	65.71	65.83	1922547.0
2012-11-30 11:00:00	QQQ	ETF	65.83	65.85	65.64	65.7	1956647.0
2012-11-30 11:30:00	QQQ	ETF	65.7	65.78	65.61	65.745	1389252.0
2012-11-30 12:00:00	QQQ	ETF	65.75	65.79	65.7175	65.7699	864226.0
2012-11-30 12:30:00	QQQ	ETF	65.77	65.82	65.67	65.715	1790565.0
2012-11-30 13:00:00	QQQ	ETF	65.72	65.84	65.7	65.795	975714.0

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

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