PREVIEW / etf_30min / 2017-03-06

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-06.parquet
  size:    431 KB
  rows:    14,728

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-03-06 04:00:00	SPY	ETF	237.52	237.9	237.36	237.46	7438.0
2017-03-06 04:30:00	SPY	ETF	237.67	237.87	237.62	237.81	8006.0
2017-03-06 05:00:00	SPY	ETF	237.73	237.8	237.65	237.8	2340.0
2017-03-06 05:30:00	SPY	ETF	237.81	237.81	237.7	237.76	3350.0
2017-03-06 06:00:00	SPY	ETF	237.77	237.86	237.77	237.8	11856.0
2017-03-06 06:30:00	SPY	ETF	237.77	237.91	237.77	237.9	4509.0
2017-03-06 07:00:00	SPY	ETF	237.91	237.91	237.78	237.85	54214.0
2017-03-06 07:30:00	SPY	ETF	237.86	237.88	237.76	237.78	32385.0
2017-03-06 08:00:00	SPY	ETF	237.84	237.9	237.66	237.69	168874.0
2017-03-06 08:30:00	SPY	ETF	237.7	237.74	237.61	237.66	193233.0
2017-03-06 09:00:00	SPY	ETF	237.68	237.77	237.45	237.47	200443.0
2017-03-06 09:30:00	SPY	ETF	237.5	237.63	237.17	237.58	6697650.0
2017-03-06 10:00:00	SPY	ETF	237.589	237.63	237.26	237.295	4248233.0
2017-03-06 10:30:00	SPY	ETF	237.3	237.31	237.03	237.12	3814514.0
2017-03-06 11:00:00	SPY	ETF	237.115	237.36	237.01	237.27	2179200.0
2017-03-06 11:30:00	SPY	ETF	237.27	237.29	237.125	237.1835	1628409.0
2017-03-06 12:00:00	SPY	ETF	237.18	237.43	237.13	237.375	1466133.0
2017-03-06 12:30:00	SPY	ETF	237.375	237.55	237.35	237.53	2186324.0
2017-03-06 13:00:00	SPY	ETF	237.53	237.925	237.52	237.86	4033326.0
2017-03-06 13:30:00	SPY	ETF	237.8599	237.95	237.7	237.7847	2307337.0
2017-03-06 14:00:00	SPY	ETF	237.78	237.84	237.72	237.765	1052748.0
2017-03-06 14:30:00	SPY	ETF	237.76	237.85	237.72	237.79	2596737.0
2017-03-06 15:00:00	SPY	ETF	237.8	238.01	237.79	237.885	4526612.0
2017-03-06 15:30:00	SPY	ETF	237.88	238.12	237.71	237.76	9995471.0
2017-03-06 16:00:00	SPY	ETF	237.75	237.87	237.64	237.82	5154931.0
2017-03-06 16:30:00	SPY	ETF	237.81	237.94	237.34	237.34	778475.0
2017-03-06 17:00:00	SPY	ETF	237.36	237.71	237.31	237.39	188558.0
2017-03-06 17:30:00	SPY	ETF	237.39	237.42	237.36	237.4	21717.0
2017-03-06 18:00:00	SPY	ETF	237.39	237.82	237.35	237.42	916646.0
2017-03-06 18:30:00	SPY	ETF	237.41	237.48	237.38	237.47	6575.0
2017-03-06 19:00:00	SPY	ETF	237.47	237.53	237.46	237.47	15909.0
2017-03-06 19:30:00	SPY	ETF	237.47	237.57	237.47	237.55	21811.0
2017-03-06 04:00:00	QQQ	ETF	130.8	130.94	130.5	130.94	2350.0
2017-03-06 04:30:00	QQQ	ETF	130.67	130.7	130.67	130.7	450.0
2017-03-06 05:00:00	QQQ	ETF	130.79	130.79	130.79	130.79	699.0
2017-03-06 05:30:00	QQQ	ETF	130.78	130.78	130.73	130.73	15440.0
2017-03-06 06:00:00	QQQ	ETF	130.76	130.82	130.76	130.82	15179.0
2017-03-06 07:00:00	QQQ	ETF	130.8	130.8	130.78	130.79	2277.0
2017-03-06 07:30:00	QQQ	ETF	130.79	130.79	130.75	130.76	1749.0
2017-03-06 08:00:00	QQQ	ETF	130.74	130.78	130.66	130.66	31811.0
2017-03-06 08:30:00	QQQ	ETF	130.68	130.68	130.62	130.68	79655.0
2017-03-06 09:00:00	QQQ	ETF	130.66	130.68	130.54	130.56	158261.0
2017-03-06 09:30:00	QQQ	ETF	130.56	130.7	130.365	130.54	1365922.0
2017-03-06 10:00:00	QQQ	ETF	130.53	130.54	130.24	130.29	1361160.0
2017-03-06 10:30:00	QQQ	ETF	130.2885	130.37	130.21	130.3	726676.0
2017-03-06 11:00:00	QQQ	ETF	130.29	130.44	130.23	130.3765	493619.0
2017-03-06 11:30:00	QQQ	ETF	130.38	130.4	130.3	130.34	403192.0
2017-03-06 12:00:00	QQQ	ETF	130.33	130.4599	130.31	130.4	374715.0
2017-03-06 12:30:00	QQQ	ETF	130.4071	130.55	130.4	130.52	440821.0
2017-03-06 13:00:00	QQQ	ETF	130.515	130.825	130.51	130.7899	972084.0

> showing 50 of 14,728 rows — these rows as CSV

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