PREVIEW / etf_30min / 2012-10-31

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-31.parquet
  size:    294 KB
  rows:    10,013

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-10-31 04:00:00	SPY	ETF	141.95	142.31	141.94	142.31	94595.0
2012-10-31 04:30:00	SPY	ETF	142.3	142.31	142.2	142.2	9225.0
2012-10-31 05:00:00	SPY	ETF	142.2	142.31	142.17	142.31	79404.0
2012-10-31 05:30:00	SPY	ETF	142.305	142.305	142.26	142.29	5600.0
2012-10-31 06:00:00	SPY	ETF	142.29	142.3	142.26	142.26	3900.0
2012-10-31 06:30:00	SPY	ETF	142.25	142.35	142.205	142.23	223135.0
2012-10-31 07:00:00	SPY	ETF	142.22	142.28	142.09	142.25	109295.0
2012-10-31 07:30:00	SPY	ETF	142.22	142.26	142.1	142.14	78090.0
2012-10-31 08:00:00	SPY	ETF	142.14	142.21	140.55	141.97	523802.0
2012-10-31 08:30:00	SPY	ETF	141.97	142.26	141.92	141.98	489625.0
2012-10-31 09:00:00	SPY	ETF	141.98	141.98	141.81	141.85	941107.0
2012-10-31 09:30:00	SPY	ETF	141.85	142.03	141.56	141.755	12773352.0
2012-10-31 10:00:00	SPY	ETF	141.75	141.83	141.49	141.64	7447044.0
2012-10-31 10:30:00	SPY	ETF	141.645	141.65	141.17	141.26	6459181.0
2012-10-31 11:00:00	SPY	ETF	141.27	141.27	140.84	141.15	9086040.0
2012-10-31 11:30:00	SPY	ETF	141.14	141.311	141.05	141.1	5757816.0
2012-10-31 12:00:00	SPY	ETF	141.09	141.11	140.76	140.77	5815336.0
2012-10-31 12:30:00	SPY	ETF	140.802	140.99	140.68	140.97	5923500.0
2012-10-31 13:00:00	SPY	ETF	140.97	141.05	140.8	141.019	3902524.0
2012-10-31 13:30:00	SPY	ETF	141.019	141.11	140.92	141.04	2813383.0
2012-10-31 14:00:00	SPY	ETF	141.05	141.3	141.03	141.21	3032891.0
2012-10-31 14:30:00	SPY	ETF	141.21	141.3	141.04	141.09	3924861.0
2012-10-31 15:00:00	SPY	ETF	141.08	141.58	140.95	141.53	8365556.0
2012-10-31 15:30:00	SPY	ETF	141.54	141.55	141.24	141.25	10428544.0
2012-10-31 16:00:00	SPY	ETF	141.24	141.3456	140.73	140.84	7897514.0
2012-10-31 16:30:00	SPY	ETF	140.84	141.18	140.74	140.8	470766.0
2012-10-31 17:00:00	SPY	ETF	140.8	140.84	140.73	140.78	143279.0
2012-10-31 17:30:00	SPY	ETF	140.78	140.84	140.78	140.8	24803.0
2012-10-31 18:00:00	SPY	ETF	140.79	141.1484	140.71	140.79	89762.0
2012-10-31 18:30:00	SPY	ETF	140.79	140.87	140.79	140.87	21151.0
2012-10-31 19:00:00	SPY	ETF	140.87	140.92	140.85	140.89	51144.0
2012-10-31 19:30:00	SPY	ETF	140.9	140.9	140.77	140.78	24770.0
2012-10-31 04:00:00	QQQ	ETF	65.5	65.63	65.5	65.63	1300.0
2012-10-31 04:30:00	QQQ	ETF	65.72	65.72	65.72	65.72	100.0
2012-10-31 05:00:00	QQQ	ETF	65.75	65.75	65.75	65.75	500.0
2012-10-31 05:30:00	QQQ	ETF	65.69	65.69	65.69	65.69	400.0
2012-10-31 06:30:00	QQQ	ETF	65.65	65.68	65.64	65.64	74900.0
2012-10-31 07:00:00	QQQ	ETF	65.635	65.635	65.55	65.6	46005.0
2012-10-31 07:30:00	QQQ	ETF	65.6	65.61	65.56	65.56	62640.0
2012-10-31 08:00:00	QQQ	ETF	65.56	65.57	65.41	65.41	79720.0
2012-10-31 08:30:00	QQQ	ETF	65.42	65.42	65.33	65.4	93777.0
2012-10-31 09:00:00	QQQ	ETF	65.39	65.44	65.31	65.31	147823.0
2012-10-31 09:30:00	QQQ	ETF	65.32	65.39	65.1101	65.15	5745267.0
2012-10-31 10:00:00	QQQ	ETF	65.15	65.22	64.95	65.06	3831451.0
2012-10-31 10:30:00	QQQ	ETF	65.06	65.07	64.83	64.895	3621201.0
2012-10-31 11:00:00	QQQ	ETF	64.89	64.99	64.73	64.9392	2675902.0
2012-10-31 11:30:00	QQQ	ETF	64.94	65.04	64.86	64.89	1539652.0
2012-10-31 12:00:00	QQQ	ETF	64.88	64.9072	64.77	64.77	1718808.0
2012-10-31 12:30:00	QQQ	ETF	64.78	64.93	64.73	64.93	1566850.0
2012-10-31 13:00:00	QQQ	ETF	64.93	64.9383	64.8	64.91	1349561.0

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

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