PREVIEW / etf_30min / 2015-06-09

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-09.parquet
  size:    376 KB
  rows:    12,744

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-06-09 04:00:00	SPY	ETF	208.62	208.7	208.62	208.68	2913.0
2015-06-09 04:30:00	SPY	ETF	208.63	208.63	208.28	208.4	28040.0
2015-06-09 05:00:00	SPY	ETF	208.38	208.38	207.5	207.95	104334.0
2015-06-09 05:30:00	SPY	ETF	207.97	208.02	207.54	207.62	107684.0
2015-06-09 06:00:00	SPY	ETF	207.62	207.91	207.5	207.89	87637.0
2015-06-09 06:30:00	SPY	ETF	207.88	208.25	207.8	208.22	46212.0
2015-06-09 07:00:00	SPY	ETF	208.22	208.32	208.05	208.25	148810.0
2015-06-09 07:30:00	SPY	ETF	208.29	208.34	208.2	208.25	144707.0
2015-06-09 08:00:00	SPY	ETF	208.25	208.3	208.05	208.29	200541.0
2015-06-09 08:30:00	SPY	ETF	208.28	209.12	208.08	208.3	279570.0
2015-06-09 09:00:00	SPY	ETF	208.29	208.61	208.21	208.42	848309.0
2015-06-09 09:30:00	SPY	ETF	208.45	208.82	207.91	207.98	13741320.0
2015-06-09 10:00:00	SPY	ETF	207.97	208.36	207.775	207.845	11349714.0
2015-06-09 10:30:00	SPY	ETF	207.84	208.6	207.69	208.56	8654236.0
2015-06-09 11:00:00	SPY	ETF	208.57	208.74	208.41	208.595	7098026.0
2015-06-09 11:30:00	SPY	ETF	208.595	208.91	208.58	208.69	5968193.0
2015-06-09 12:00:00	SPY	ETF	208.7	208.77	208.5	208.64	4029482.0
2015-06-09 12:30:00	SPY	ETF	208.64	208.88	208.59	208.8649	2914693.0
2015-06-09 13:00:00	SPY	ETF	208.87	209.07	208.869	209.0562	3991290.0
2015-06-09 13:30:00	SPY	ETF	209.06	209.1	208.63	208.695	4565795.0
2015-06-09 14:00:00	SPY	ETF	208.695	208.86	208.64	208.82	3700041.0
2015-06-09 14:30:00	SPY	ETF	208.83	209.02	208.67	208.76	3885093.0
2015-06-09 15:00:00	SPY	ETF	208.75	208.81	208.33	208.42	6013402.0
2015-06-09 15:30:00	SPY	ETF	208.425	208.8099	208.27	208.45	13104733.0
2015-06-09 16:00:00	SPY	ETF	208.44	208.85	208.3	208.68	5539228.0
2015-06-09 16:30:00	SPY	ETF	208.67	208.79	208.45	208.72	2910157.0
2015-06-09 17:00:00	SPY	ETF	208.72	208.72	208.4351	208.69	2061722.0
2015-06-09 17:30:00	SPY	ETF	208.69	208.72	208.69	208.7	45765.0
2015-06-09 18:00:00	SPY	ETF	208.69	208.75	208.65	208.68	34100.0
2015-06-09 18:30:00	SPY	ETF	208.69	208.73	208.68	208.73	48141.0
2015-06-09 19:00:00	SPY	ETF	208.75	208.76	208.73	208.759	15546.0
2015-06-09 19:30:00	SPY	ETF	208.74	208.84	208.72	208.84	32166.0
2015-06-09 04:30:00	QQQ	ETF	108.08	108.1	108.02	108.02	7650.0
2015-06-09 05:00:00	QQQ	ETF	108.0	108.0	108.0	108.0	317.0
2015-06-09 05:30:00	QQQ	ETF	107.81	107.81	107.53	107.59	14600.0
2015-06-09 06:00:00	QQQ	ETF	107.68	107.78	107.6	107.78	35050.0
2015-06-09 06:30:00	QQQ	ETF	107.75	107.91	107.75	107.9	13000.0
2015-06-09 07:00:00	QQQ	ETF	107.93	108.0	107.85	107.98	34100.0
2015-06-09 07:30:00	QQQ	ETF	107.96	107.99	107.93	107.93	12600.0
2015-06-09 08:00:00	QQQ	ETF	107.93	107.94	107.85	107.94	39780.0
2015-06-09 08:30:00	QQQ	ETF	107.94	107.95	107.8	107.9	115092.0
2015-06-09 09:00:00	QQQ	ETF	107.9	108.02	107.88	107.94	97775.0
2015-06-09 09:30:00	QQQ	ETF	107.93	108.12	107.45	107.53	3551198.0
2015-06-09 10:00:00	QQQ	ETF	107.53	107.69	107.28	107.32	3542438.0
2015-06-09 10:30:00	QQQ	ETF	107.31	107.84	107.2	107.81	2843851.0
2015-06-09 11:00:00	QQQ	ETF	107.82	107.96	107.77	107.9057	1375342.0
2015-06-09 11:30:00	QQQ	ETF	107.91	108.11	107.89	107.953	1106224.0
2015-06-09 12:00:00	QQQ	ETF	107.96	107.995	107.78	107.9039	584257.0
2015-06-09 12:30:00	QQQ	ETF	107.9	108.18	107.88	108.179	849001.0
2015-06-09 13:00:00	QQQ	ETF	108.18	108.35	108.18	108.3462	1207900.0

> showing 50 of 12,744 rows — these rows as CSV

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