PREVIEW / etf_30min / 2015-03-10

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-10.parquet
  size:    391 KB
  rows:    13,285

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
2015-03-10 04:00:00	SPY	ETF	207.96	207.96	207.54	207.54	828.0
2015-03-10 04:30:00	SPY	ETF	207.5	207.6	207.38	207.44	25338.0
2015-03-10 05:00:00	SPY	ETF	207.48	207.48	207.34	207.34	36355.0
2015-03-10 05:30:00	SPY	ETF	207.33	207.33	207.19	207.24	16448.0
2015-03-10 06:00:00	SPY	ETF	207.16	207.16	206.74	206.84	63627.0
2015-03-10 06:30:00	SPY	ETF	206.88	207.13	206.88	207.05	124299.0
2015-03-10 07:00:00	SPY	ETF	207.05	207.09	206.51	206.55	293571.0
2015-03-10 07:30:00	SPY	ETF	206.56	206.68	206.42	206.53	236994.0
2015-03-10 08:00:00	SPY	ETF	206.56	207.09	206.13	206.28	1011289.0
2015-03-10 08:30:00	SPY	ETF	206.28	206.75	206.26	206.57	961910.0
2015-03-10 09:00:00	SPY	ETF	206.57	206.84	206.54	206.72	854847.0
2015-03-10 09:30:00	SPY	ETF	206.71	206.81	206.02	206.3201	13199133.0
2015-03-10 10:00:00	SPY	ETF	206.32	206.51	205.79	206.07	12170231.0
2015-03-10 10:30:00	SPY	ETF	206.075	206.27	205.7	206.08	10516748.0
2015-03-10 11:00:00	SPY	ETF	206.08	206.66	206.06	206.41	7960745.0
2015-03-10 11:30:00	SPY	ETF	206.4	206.5	205.57	205.58	10274318.0
2015-03-10 12:00:00	SPY	ETF	205.58	205.8	205.33	205.42	9516420.0
2015-03-10 12:30:00	SPY	ETF	205.42	205.79	205.32	205.56	9522452.0
2015-03-10 13:00:00	SPY	ETF	205.57	205.98	205.48	205.77	5623310.0
2015-03-10 13:30:00	SPY	ETF	205.78	205.81	205.55	205.68	7748581.0
2015-03-10 14:00:00	SPY	ETF	205.67	205.92	205.22	205.2801	7442302.0
2015-03-10 14:30:00	SPY	ETF	205.28	205.575	205.22	205.2601	7564796.0
2015-03-10 15:00:00	SPY	ETF	205.26	205.74	205.18	205.44	10632469.0
2015-03-10 15:30:00	SPY	ETF	205.44	205.525	204.97	204.98	22494422.0
2015-03-10 16:00:00	SPY	ETF	204.97	208.3738	204.67	208.3738	10239197.0
2015-03-10 16:30:00	SPY	ETF	204.79	206.32	204.79	205.0	3437582.0
2015-03-10 17:00:00	SPY	ETF	204.93	204.98	204.88	204.88	1311459.0
2015-03-10 17:30:00	SPY	ETF	204.88	204.94	204.88	204.94	103314.0
2015-03-10 18:00:00	SPY	ETF	204.93	204.94	204.87	204.87	181284.0
2015-03-10 18:30:00	SPY	ETF	204.88	204.97	204.88	204.94	42843.0
2015-03-10 19:00:00	SPY	ETF	204.96	205.05	204.91	205.05	76447.0
2015-03-10 19:30:00	SPY	ETF	205.05	205.21	205.03	205.18	84530.0
2015-03-10 04:00:00	QQQ	ETF	107.38	107.38	107.38	107.38	2500.0
2015-03-10 05:30:00	QQQ	ETF	107.31	107.31	107.25	107.29	11501.0
2015-03-10 06:00:00	QQQ	ETF	107.28	107.28	106.92	106.97	46136.0
2015-03-10 06:30:00	QQQ	ETF	106.97	107.13	106.97	107.13	33800.0
2015-03-10 07:00:00	QQQ	ETF	107.06	107.06	106.87	106.87	42200.0
2015-03-10 07:30:00	QQQ	ETF	106.86	106.96	106.86	106.92	30766.0
2015-03-10 08:00:00	QQQ	ETF	106.92	106.93	106.7	106.75	230862.0
2015-03-10 08:30:00	QQQ	ETF	106.75	107.0	106.75	106.93	74171.0
2015-03-10 09:00:00	QQQ	ETF	106.94	107.04	106.92	106.94	77040.0
2015-03-10 09:30:00	QQQ	ETF	106.95	106.98	106.39	106.5162	4831026.0
2015-03-10 10:00:00	QQQ	ETF	106.51	106.65	106.145	106.3	2743709.0
2015-03-10 10:30:00	QQQ	ETF	106.2945	106.3	105.96	106.19	2103650.0
2015-03-10 11:00:00	QQQ	ETF	106.18	106.56	106.161	106.42	1558049.0
2015-03-10 11:30:00	QQQ	ETF	106.41	106.51	105.99	105.99	1759330.0
2015-03-10 12:00:00	QQQ	ETF	105.985	106.11	105.87	105.93	2332400.0
2015-03-10 12:30:00	QQQ	ETF	105.93	106.15	105.85	106.03	1285123.0
2015-03-10 13:00:00	QQQ	ETF	106.03	106.299	105.98	106.17	1243220.0
2015-03-10 13:30:00	QQQ	ETF	106.16	106.27	106.05	106.18	1811871.0

> showing 50 of 13,285 rows — these rows as CSV

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