PREVIEW / etf_30min / 2015-03-20

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-03-20.parquet
  size:    386 KB
  rows:    12,919

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-20 04:00:00	SPY	ETF	209.27	209.36	209.14	209.2	35947.0
2015-03-20 04:30:00	SPY	ETF	209.2	209.2	209.05	209.05	26200.0
2015-03-20 05:00:00	SPY	ETF	209.05	209.17	209.05	209.17	1170.0
2015-03-20 05:30:00	SPY	ETF	209.11	209.11	209.09	209.09	400.0
2015-03-20 06:00:00	SPY	ETF	209.12	209.2	209.05	209.2	3900.0
2015-03-20 06:30:00	SPY	ETF	209.2	209.4	209.2	209.21	31675.0
2015-03-20 07:00:00	SPY	ETF	209.21	209.34	209.21	209.34	32185.0
2015-03-20 07:30:00	SPY	ETF	209.3	209.66	209.3	209.63	102829.0
2015-03-20 08:00:00	SPY	ETF	209.64	209.78	209.21	209.76	382963.0
2015-03-20 08:30:00	SPY	ETF	209.75	210.05	209.69	209.96	1131052.0
2015-03-20 09:00:00	SPY	ETF	209.95	210.12	209.59	209.7	3565983.0
2015-03-20 09:30:00	SPY	ETF	209.71	210.02	209.61	209.82	17730910.0
2015-03-20 10:00:00	SPY	ETF	209.82	210.01	209.75	209.86	17456493.0
2015-03-20 10:30:00	SPY	ETF	209.865	210.35	209.85	210.25	14702449.0
2015-03-20 11:00:00	SPY	ETF	210.26	210.5872	210.24	210.53	7100695.0
2015-03-20 11:30:00	SPY	ETF	210.53	210.61	210.38	210.47	6395287.0
2015-03-20 12:00:00	SPY	ETF	210.47	210.6	210.43	210.47	5037204.0
2015-03-20 12:30:00	SPY	ETF	210.475	210.84	210.45	210.77	8726085.0
2015-03-20 13:00:00	SPY	ETF	210.775	211.02	210.72	210.93	8284312.0
2015-03-20 13:30:00	SPY	ETF	210.9338	211.0	210.82	210.865	4200684.0
2015-03-20 14:00:00	SPY	ETF	210.8606	210.98	210.66	210.765	5774683.0
2015-03-20 14:30:00	SPY	ETF	210.76	210.96	210.7	210.95	9057397.0
2015-03-20 15:00:00	SPY	ETF	210.96	210.995	210.36	210.485	11501040.0
2015-03-20 15:30:00	SPY	ETF	210.49	210.82	210.41	210.42	25159513.0
2015-03-20 16:00:00	SPY	ETF	210.42	210.46	208.5168	210.31	12900585.0
2015-03-20 16:30:00	SPY	ETF	210.31	210.5	210.29	210.29	13358661.0
2015-03-20 17:00:00	SPY	ETF	210.3	210.45	210.22	210.34	1857808.0
2015-03-20 17:30:00	SPY	ETF	210.34	210.47	210.34	210.46	101802.0
2015-03-20 18:00:00	SPY	ETF	210.46	210.5	210.4	210.46	93774.0
2015-03-20 18:30:00	SPY	ETF	210.46	210.5	210.46	210.5	38364.0
2015-03-20 19:00:00	SPY	ETF	210.48	210.5	210.47	210.47	7968.0
2015-03-20 19:30:00	SPY	ETF	210.47	210.49	210.47	210.47	14065.0
2015-03-20 04:00:00	QQQ	ETF	108.0	108.2	108.0	108.19	606.0
2015-03-20 04:30:00	QQQ	ETF	108.2	108.2	108.16	108.16	400.0
2015-03-20 06:00:00	QQQ	ETF	108.2	108.2	108.2	108.2	3000.0
2015-03-20 06:30:00	QQQ	ETF	108.18	108.18	108.18	108.18	100.0
2015-03-20 07:00:00	QQQ	ETF	108.29	108.29	108.27	108.27	442.0
2015-03-20 07:30:00	QQQ	ETF	108.28	108.59	108.28	108.59	15800.0
2015-03-20 08:00:00	QQQ	ETF	108.37	108.6	108.28	108.6	99549.0
2015-03-20 08:30:00	QQQ	ETF	108.6	108.75	108.6	108.7	325098.0
2015-03-20 09:00:00	QQQ	ETF	108.71	108.82	108.65	108.71	1135927.0
2015-03-20 09:30:00	QQQ	ETF	108.72	108.79	108.53	108.65	3689201.0
2015-03-20 10:00:00	QQQ	ETF	108.66	108.74	108.51	108.57	1629264.0
2015-03-20 10:30:00	QQQ	ETF	108.57	108.83	108.55	108.65	2256711.0
2015-03-20 11:00:00	QQQ	ETF	108.66	108.9	108.655	108.8899	1441475.0
2015-03-20 11:30:00	QQQ	ETF	108.88	108.94	108.76	108.82	751861.0
2015-03-20 12:00:00	QQQ	ETF	108.81	108.89	108.76	108.77	663456.0
2015-03-20 12:30:00	QQQ	ETF	108.78	108.96	108.7542	108.905	781888.0
2015-03-20 13:00:00	QQQ	ETF	108.91	109.04	108.91	109.02	1542368.0
2015-03-20 13:30:00	QQQ	ETF	109.0275	109.07	108.95	108.98	623897.0

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

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