PREVIEW / etf_30min / 2015-08-19

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-08-19.parquet
  size:    391 KB
  rows:    12,976

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-08-19 04:00:00	SPY	ETF	209.66	209.66	209.06	209.06	11271.0
2015-08-19 04:30:00	SPY	ETF	209.17	209.29	209.16	209.23	39014.0
2015-08-19 05:00:00	SPY	ETF	209.2	209.39	209.2	209.36	9432.0
2015-08-19 05:30:00	SPY	ETF	209.53	209.54	209.35	209.42	3600.0
2015-08-19 06:00:00	SPY	ETF	209.43	209.75	209.43	209.71	5130.0
2015-08-19 06:30:00	SPY	ETF	209.71	209.71	209.47	209.62	45566.0
2015-08-19 07:00:00	SPY	ETF	209.64	209.64	209.42	209.59	125140.0
2015-08-19 07:30:00	SPY	ETF	209.53	209.59	209.33	209.34	214043.0
2015-08-19 08:00:00	SPY	ETF	209.37	209.62	209.25	209.43	253277.0
2015-08-19 08:30:00	SPY	ETF	209.45	209.6	209.33	209.38	182122.0
2015-08-19 09:00:00	SPY	ETF	209.39	209.9	209.06	209.08	1578391.0
2015-08-19 09:30:00	SPY	ETF	209.09	209.1	208.16	208.28	16798260.0
2015-08-19 10:00:00	SPY	ETF	208.28	208.83	208.17	208.67	7445434.0
2015-08-19 10:30:00	SPY	ETF	208.665	208.665	207.73	207.9	12273920.0
2015-08-19 11:00:00	SPY	ETF	207.9	208.175	207.51	207.64	11008119.0
2015-08-19 11:30:00	SPY	ETF	207.645	207.866	207.35	207.71	8453032.0
2015-08-19 12:00:00	SPY	ETF	207.71	207.86	207.55	207.81	6059040.0
2015-08-19 12:30:00	SPY	ETF	207.81	208.25	207.76	208.11	5831913.0
2015-08-19 13:00:00	SPY	ETF	208.11	208.49	208.03	208.0902	7224625.0
2015-08-19 13:30:00	SPY	ETF	208.1	208.87	208.02	208.37	12411343.0
2015-08-19 14:00:00	SPY	ETF	208.3601	210.01	208.33	209.38	21283358.0
2015-08-19 14:30:00	SPY	ETF	209.38	209.45	208.22	208.355	13422083.0
2015-08-19 15:00:00	SPY	ETF	208.36	208.71	208.08	208.58	12405037.0
2015-08-19 15:30:00	SPY	ETF	208.58	208.97	208.31	208.32	19082032.0
2015-08-19 16:00:00	SPY	ETF	208.31	208.84	207.5014	207.93	7232756.0
2015-08-19 16:30:00	SPY	ETF	207.94	208.32	207.74	208.0	1401881.0
2015-08-19 17:00:00	SPY	ETF	207.98	208.32	207.86	207.99	1328775.0
2015-08-19 17:30:00	SPY	ETF	207.99	208.01	207.97	208.0	10466.0
2015-08-19 18:00:00	SPY	ETF	207.97	208.1	207.95	208.03	73359.0
2015-08-19 18:30:00	SPY	ETF	208.07	208.09	208.01	208.08	30539.0
2015-08-19 19:00:00	SPY	ETF	208.07	208.14	208.03	208.14	16194.0
2015-08-19 19:30:00	SPY	ETF	208.13	208.18	208.08	208.1	38294.0
2015-08-19 04:00:00	QQQ	ETF	110.5	110.66	110.44	110.44	30600.0
2015-08-19 04:30:00	QQQ	ETF	110.4	110.4	110.4	110.4	4000.0
2015-08-19 05:30:00	QQQ	ETF	110.61	110.61	110.61	110.61	500.0
2015-08-19 06:00:00	QQQ	ETF	110.68	110.76	110.62	110.74	18100.0
2015-08-19 06:30:00	QQQ	ETF	110.71	110.71	110.66	110.67	1200.0
2015-08-19 07:00:00	QQQ	ETF	110.69	110.71	110.66	110.67	25600.0
2015-08-19 07:30:00	QQQ	ETF	110.72	110.73	110.65	110.67	65300.0
2015-08-19 08:00:00	QQQ	ETF	110.67	110.7	110.64	110.68	19198.0
2015-08-19 08:30:00	QQQ	ETF	110.75	110.77	110.64	110.69	18630.0
2015-08-19 09:00:00	QQQ	ETF	110.71	110.71	110.52	110.52	56187.0
2015-08-19 09:30:00	QQQ	ETF	110.52	110.53	109.9	109.99	5006615.0
2015-08-19 10:00:00	QQQ	ETF	110.0	110.43	109.94	110.35	2840210.0
2015-08-19 10:30:00	QQQ	ETF	110.345	110.345	109.84	109.96	2665204.0
2015-08-19 11:00:00	QQQ	ETF	109.94	110.11	109.68	109.73	2267183.0
2015-08-19 11:30:00	QQQ	ETF	109.73	109.85	109.49	109.7	1986852.0
2015-08-19 12:00:00	QQQ	ETF	109.69	109.8	109.61	109.75	1036942.0
2015-08-19 12:30:00	QQQ	ETF	109.76	110.02	109.73	109.97	1985499.0
2015-08-19 13:00:00	QQQ	ETF	109.97	110.2368	109.93	109.98	1295251.0

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

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