PREVIEW / etf_30min / 2017-07-18

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-07-18.parquet
  size:    435 KB
  rows:    15,103

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
2017-07-18 04:00:00	SPY	ETF	245.45	245.68	245.45	245.67	33450.0
2017-07-18 04:30:00	SPY	ETF	245.7	245.9	245.69	245.88	58627.0
2017-07-18 05:00:00	SPY	ETF	245.83	245.88	245.73	245.73	18400.0
2017-07-18 05:30:00	SPY	ETF	245.73	245.73	245.73	245.73	200.0
2017-07-18 06:00:00	SPY	ETF	245.85	245.85	245.73	245.73	7600.0
2017-07-18 06:30:00	SPY	ETF	245.76	245.76	245.62	245.63	5260.0
2017-07-18 07:00:00	SPY	ETF	245.67	245.71	245.6	245.6	35147.0
2017-07-18 07:30:00	SPY	ETF	245.63	245.63	245.5	245.55	54355.0
2017-07-18 08:00:00	SPY	ETF	245.56	245.67	245.44	245.45	58918.0
2017-07-18 08:30:00	SPY	ETF	245.47	245.52	245.1	245.11	649323.0
2017-07-18 09:00:00	SPY	ETF	245.11	245.26	245.04	245.07	263043.0
2017-07-18 09:30:00	SPY	ETF	245.06	245.23	244.88	245.14	6417609.0
2017-07-18 10:00:00	SPY	ETF	245.14	245.35	245.02	245.21	2714094.0
2017-07-18 10:30:00	SPY	ETF	245.22	245.24	244.67	245.225	4643804.0
2017-07-18 11:00:00	SPY	ETF	245.22	245.34	245.07	245.28	2195169.0
2017-07-18 11:30:00	SPY	ETF	245.28	245.46	245.27	245.39	1846764.0
2017-07-18 12:00:00	SPY	ETF	245.39	245.46	245.25	245.37	2585667.0
2017-07-18 12:30:00	SPY	ETF	245.37	245.43	245.21	245.23	1813437.0
2017-07-18 13:00:00	SPY	ETF	245.23	245.39	245.1	245.305	1496354.0
2017-07-18 13:30:00	SPY	ETF	245.3	245.49	245.28	245.44	1424959.0
2017-07-18 14:00:00	SPY	ETF	245.43	245.52	245.35	245.39	1118702.0
2017-07-18 14:30:00	SPY	ETF	245.39	245.55	245.39	245.46	1659387.0
2017-07-18 15:00:00	SPY	ETF	245.45	245.66	245.43	245.64	1579741.0
2017-07-18 15:30:00	SPY	ETF	245.64	245.72	245.52	245.69	5943160.0
2017-07-18 16:00:00	SPY	ETF	245.68	245.8	244.9574	245.7	4102760.0
2017-07-18 16:30:00	SPY	ETF	245.72	245.93	245.66	245.85	648265.0
2017-07-18 17:00:00	SPY	ETF	245.85	245.91	245.6762	245.9	306764.0
2017-07-18 17:30:00	SPY	ETF	245.9	245.92	245.86	245.87	67317.0
2017-07-18 18:00:00	SPY	ETF	245.86	245.86	245.68	245.74	170242.0
2017-07-18 18:30:00	SPY	ETF	245.76	245.76	245.71	245.72	7327.0
2017-07-18 19:00:00	SPY	ETF	245.76	245.76	245.76	245.76	3176.0
2017-07-18 19:30:00	SPY	ETF	245.76	245.76	245.71	245.74	10024.0
2017-07-18 04:00:00	QQQ	ETF	142.4	142.52	142.4	142.52	200.0
2017-07-18 04:30:00	QQQ	ETF	142.59	142.59	142.59	142.59	340.0
2017-07-18 05:00:00	QQQ	ETF	142.58	142.58	142.58	142.58	500.0
2017-07-18 05:30:00	QQQ	ETF	142.61	142.61	142.56	142.56	20600.0
2017-07-18 06:00:00	QQQ	ETF	142.59	142.59	142.52	142.52	3612.0
2017-07-18 06:30:00	QQQ	ETF	142.5	142.5	142.45	142.45	4116.0
2017-07-18 07:00:00	QQQ	ETF	142.49	142.49	142.41	142.41	12600.0
2017-07-18 07:30:00	QQQ	ETF	142.36	142.38	142.3	142.31	83309.0
2017-07-18 08:00:00	QQQ	ETF	142.33	142.83	142.22	142.25	204759.0
2017-07-18 08:30:00	QQQ	ETF	142.23	142.28	141.96	141.96	62121.0
2017-07-18 09:00:00	QQQ	ETF	141.95	142.833	141.95	142.09	169921.0
2017-07-18 09:30:00	QQQ	ETF	142.06	142.24	141.64	142.1599	2788557.0
2017-07-18 10:00:00	QQQ	ETF	142.16	142.43	142.04	142.4	2352383.0
2017-07-18 10:30:00	QQQ	ETF	142.4	142.55	142.01	142.53	2183688.0
2017-07-18 11:00:00	QQQ	ETF	142.53	142.5999	142.38	142.54	1114801.0
2017-07-18 11:30:00	QQQ	ETF	142.54	142.77	142.54	142.7	1344599.0
2017-07-18 12:00:00	QQQ	ETF	142.71	142.785	142.61	142.645	813013.0
2017-07-18 12:30:00	QQQ	ETF	142.64	142.7201	142.56	142.65	469729.0

> showing 50 of 15,103 rows — these rows as CSV

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