PREVIEW / etf_30min / 2012-12-21

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-21.parquet
  size:    308 KB
  rows:    10,583

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-12-21 04:00:00	SPY	ETF	142.95	142.99	142.26	142.35	32100.0
2012-12-21 04:30:00	SPY	ETF	142.34	142.38	142.18	142.18	24605.0
2012-12-21 05:00:00	SPY	ETF	142.12	142.2	141.99	141.99	18181.0
2012-12-21 05:30:00	SPY	ETF	141.99	142.28	141.9	142.17	853770.0
2012-12-21 06:00:00	SPY	ETF	142.19	142.51	142.17	142.3	973600.0
2012-12-21 06:30:00	SPY	ETF	142.31	142.46	142.31	142.46	237210.0
2012-12-21 07:00:00	SPY	ETF	142.46	142.65	142.38	142.57	520434.0
2012-12-21 07:30:00	SPY	ETF	142.56	142.59	142.4	142.4	638510.0
2012-12-21 08:00:00	SPY	ETF	142.41	142.55	141.9481	142.14	2115091.0
2012-12-21 08:30:00	SPY	ETF	142.14	142.35	142.0	142.15	3142691.0
2012-12-21 09:00:00	SPY	ETF	142.16	142.5	141.89	142.15	4754402.0
2012-12-21 09:30:00	SPY	ETF	142.17	143.0814	142.04	142.6	35771344.0
2012-12-21 10:00:00	SPY	ETF	142.59	143.1	142.42	142.945	20438725.0
2012-12-21 10:30:00	SPY	ETF	142.94	143.01	142.61	142.62	10446803.0
2012-12-21 11:00:00	SPY	ETF	142.62	142.73	142.27	142.44	10922054.0
2012-12-21 11:30:00	SPY	ETF	142.44	142.45	141.94	142.28	13692463.0
2012-12-21 12:00:00	SPY	ETF	142.28	144.0881	142.07	142.109	7173897.0
2012-12-21 12:30:00	SPY	ETF	142.1	142.35	141.98	142.322	6669476.0
2012-12-21 13:00:00	SPY	ETF	142.32	142.44	142.12	142.31	8469315.0
2012-12-21 13:30:00	SPY	ETF	142.32	142.68	142.25	142.61	10365458.0
2012-12-21 14:00:00	SPY	ETF	142.608	142.79	142.46	142.511	9400400.0
2012-12-21 14:30:00	SPY	ETF	142.52	142.7	142.475	142.59	7180036.0
2012-12-21 15:00:00	SPY	ETF	142.585	142.76	142.45	142.76	10097155.0
2012-12-21 15:30:00	SPY	ETF	142.76	143.02	142.54	142.8	27538664.0
2012-12-21 16:00:00	SPY	ETF	142.81	144.0882	142.525	143.01	13547074.0
2012-12-21 16:30:00	SPY	ETF	143.0	143.08	142.77	143.02	6968298.0
2012-12-21 17:00:00	SPY	ETF	143.01	143.1	142.98	143.06	14048776.0
2012-12-21 17:30:00	SPY	ETF	143.07	143.1	142.94	143.01	962349.0
2012-12-21 18:00:00	SPY	ETF	142.95	143.2	142.94	143.2	84083.0
2012-12-21 18:30:00	SPY	ETF	143.2	143.2	143.0	143.0	15495.0
2012-12-21 19:00:00	SPY	ETF	143.02	143.03	143.0	143.02	58800.0
2012-12-21 19:30:00	SPY	ETF	143.03	143.1	143.03	143.1	17421.0
2012-12-21 04:00:00	QQQ	ETF	65.45	65.45	64.95	65.05	10148.0
2012-12-21 04:30:00	QQQ	ETF	64.97	64.97	64.92	64.92	13800.0
2012-12-21 05:00:00	QQQ	ETF	64.92	64.92	64.88	64.88	3200.0
2012-12-21 05:30:00	QQQ	ETF	64.88	64.95	64.88	64.95	2100.0
2012-12-21 06:00:00	QQQ	ETF	65.0	65.05	65.0	65.04	12500.0
2012-12-21 07:00:00	QQQ	ETF	65.05	65.11	64.96	65.05	16484.0
2012-12-21 07:30:00	QQQ	ETF	65.09	65.12	65.02	65.04	102480.0
2012-12-21 08:00:00	QQQ	ETF	65.06	65.09	64.85	64.86	1211706.0
2012-12-21 08:30:00	QQQ	ETF	64.87	64.95	64.78	64.9	521026.0
2012-12-21 09:00:00	QQQ	ETF	64.91	65.0	64.81	64.89	1991038.0
2012-12-21 09:30:00	QQQ	ETF	64.89	65.01	64.6	64.979	11576670.0
2012-12-21 10:00:00	QQQ	ETF	64.98	65.28	64.88	65.16	4806067.0
2012-12-21 10:30:00	QQQ	ETF	65.16	65.22	65.05	65.08	3431906.0
2012-12-21 11:00:00	QQQ	ETF	65.08	65.16	64.92	65.0	2382109.0
2012-12-21 11:30:00	QQQ	ETF	65.01	65.01	64.78	64.95	2566435.0
2012-12-21 12:00:00	QQQ	ETF	64.95	65.0	64.81	64.8499	1509256.0
2012-12-21 12:30:00	QQQ	ETF	64.84	64.965	64.78	64.95	2897357.0
2012-12-21 13:00:00	QQQ	ETF	64.96	65.01	64.84	64.95	1470935.0

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

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