PREVIEW / etf_30min / 2014-10-30

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-30.parquet
  size:    333 KB
  rows:    11,049

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
2014-10-30 04:00:00	SPY	ETF	198.41	198.52	198.37	198.42	9312.0
2014-10-30 04:30:00	SPY	ETF	198.45	198.46	198.1	198.16	25330.0
2014-10-30 05:00:00	SPY	ETF	198.03	198.06	197.34	197.59	52237.0
2014-10-30 05:30:00	SPY	ETF	197.55	197.55	197.02	197.2	52039.0
2014-10-30 06:00:00	SPY	ETF	197.32	197.4	197.2	197.23	20616.0
2014-10-30 06:30:00	SPY	ETF	197.22	197.34	196.74	196.96	231268.0
2014-10-30 07:00:00	SPY	ETF	196.92	197.04	196.71	196.75	291289.0
2014-10-30 07:30:00	SPY	ETF	196.74	196.94	196.52	196.93	765365.0
2014-10-30 08:00:00	SPY	ETF	196.93	198.59	196.58	197.15	1077027.0
2014-10-30 08:30:00	SPY	ETF	197.16	197.47	197.01	197.12	1091476.0
2014-10-30 09:00:00	SPY	ETF	197.11	197.59	196.72	197.57	1072557.0
2014-10-30 09:30:00	SPY	ETF	197.58	198.38	197.57	197.65	15347824.0
2014-10-30 10:00:00	SPY	ETF	197.64	198.17	197.4	198.1	8644152.0
2014-10-30 10:30:00	SPY	ETF	198.11	198.31	197.81	198.29	5885470.0
2014-10-30 11:00:00	SPY	ETF	198.29	198.57	198.21	198.34	6342992.0
2014-10-30 11:30:00	SPY	ETF	198.34	198.8	198.25	198.74	6000067.0
2014-10-30 12:00:00	SPY	ETF	198.74	198.86	198.52	198.8	4004458.0
2014-10-30 12:30:00	SPY	ETF	198.79	198.99	198.775	198.87	3947631.0
2014-10-30 13:00:00	SPY	ETF	198.875	199.6	198.86	199.47	3830454.0
2014-10-30 13:30:00	SPY	ETF	199.47	199.91	198.9	199.786	8726067.0
2014-10-30 14:00:00	SPY	ETF	199.79	199.95	199.38	199.405	8557087.0
2014-10-30 14:30:00	SPY	ETF	199.405	199.61	198.66	198.7857	11071444.0
2014-10-30 15:00:00	SPY	ETF	198.79	199.11	198.7	198.86	6835995.0
2014-10-30 15:30:00	SPY	ETF	198.865	199.49	198.83	199.45	12640846.0
2014-10-30 16:00:00	SPY	ETF	199.44	199.49	199.31	199.37	4432250.0
2014-10-30 16:30:00	SPY	ETF	199.37	199.48	199.33	199.45	3106798.0
2014-10-30 17:00:00	SPY	ETF	199.44	199.45	199.36	199.42	120116.0
2014-10-30 17:30:00	SPY	ETF	199.41	199.41	199.29	199.3	206750.0
2014-10-30 18:00:00	SPY	ETF	199.32	199.34	199.22	199.3	152480.0
2014-10-30 18:30:00	SPY	ETF	199.29	199.49	199.29	199.45	68128.0
2014-10-30 19:00:00	SPY	ETF	199.42	199.44	199.38	199.38	24125.0
2014-10-30 19:30:00	SPY	ETF	199.39	199.55	199.39	199.52	61906.0
2014-10-30 04:30:00	QQQ	ETF	99.68	99.68	99.62	99.62	300.0
2014-10-30 05:00:00	QQQ	ETF	99.6	99.6	99.27	99.27	15300.0
2014-10-30 05:30:00	QQQ	ETF	99.33	99.35	99.15	99.16	25330.0
2014-10-30 06:00:00	QQQ	ETF	99.3	99.32	99.25	99.25	9500.0
2014-10-30 06:30:00	QQQ	ETF	99.29	99.31	99.03	99.1	54850.0
2014-10-30 07:00:00	QQQ	ETF	99.09	99.13	98.99	98.99	165542.0
2014-10-30 07:30:00	QQQ	ETF	98.99	99.03	98.81	99.03	89980.0
2014-10-30 08:00:00	QQQ	ETF	99.02	99.18	99.02	99.14	107938.0
2014-10-30 08:30:00	QQQ	ETF	99.18	99.31	99.1	99.13	172127.0
2014-10-30 09:00:00	QQQ	ETF	99.16	99.4	99.16	99.37	212802.0
2014-10-30 09:30:00	QQQ	ETF	99.37	99.8	99.32	99.34	4624639.0
2014-10-30 10:00:00	QQQ	ETF	99.32	99.49	99.14	99.43	2394763.0
2014-10-30 10:30:00	QQQ	ETF	99.44	99.54	99.17	99.43	2200867.0
2014-10-30 11:00:00	QQQ	ETF	99.42	99.57	99.37	99.45	1489191.0
2014-10-30 11:30:00	QQQ	ETF	99.46	99.69	99.4	99.67	1174319.0
2014-10-30 12:00:00	QQQ	ETF	99.68	99.77	99.55	99.75	860629.0
2014-10-30 12:30:00	QQQ	ETF	99.74	99.84	99.71	99.764	941596.0
2014-10-30 13:00:00	QQQ	ETF	99.77	100.21	99.73	100.11	2472929.0

> showing 50 of 11,049 rows — these rows as CSV

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