PREVIEW / etf_30min / 2015-01-12

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-01-12.parquet
  size:    379 KB
  rows:    12,775

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-01-12 04:00:00	SPY	ETF	204.49	204.69	204.16	204.2	161118.0
2015-01-12 04:30:00	SPY	ETF	204.36	204.94	204.25	204.89	16150.0
2015-01-12 05:00:00	SPY	ETF	204.92	205.0	204.87	204.87	40075.0
2015-01-12 05:30:00	SPY	ETF	204.86	205.14	204.86	205.05	6800.0
2015-01-12 06:00:00	SPY	ETF	204.99	205.17	204.88	205.1	9703.0
2015-01-12 06:30:00	SPY	ETF	205.06	205.15	204.98	205.15	60098.0
2015-01-12 07:00:00	SPY	ETF	205.13	205.15	204.89	204.99	209500.0
2015-01-12 07:30:00	SPY	ETF	205.0	205.08	204.72	204.74	300576.0
2015-01-12 08:00:00	SPY	ETF	204.72	205.06	203.89	204.28	545142.0
2015-01-12 08:30:00	SPY	ETF	204.29	204.33	204.03	204.29	470583.0
2015-01-12 09:00:00	SPY	ETF	204.27	204.51	204.15	204.4	1149460.0
2015-01-12 09:30:00	SPY	ETF	204.41	204.6	202.08	202.36	21031919.0
2015-01-12 10:00:00	SPY	ETF	202.37	202.73	201.92	202.2831	14249832.0
2015-01-12 10:30:00	SPY	ETF	202.28	203.11	202.18	203.1	9383008.0
2015-01-12 11:00:00	SPY	ETF	203.11	203.3	202.88	203.01	8267975.0
2015-01-12 11:30:00	SPY	ETF	203.01	203.25	202.53	202.755	7674631.0
2015-01-12 12:00:00	SPY	ETF	202.76	203.18	202.66	202.97	5186638.0
2015-01-12 12:30:00	SPY	ETF	202.98	203.16	202.56	202.64	4243153.0
2015-01-12 13:00:00	SPY	ETF	202.65	202.86	202.31	202.33	4895737.0
2015-01-12 13:30:00	SPY	ETF	202.34	202.81	202.32	202.65	3815904.0
2015-01-12 14:00:00	SPY	ETF	202.66	202.87	202.24	202.37	5510256.0
2015-01-12 14:30:00	SPY	ETF	202.37	202.5	202.07	202.46	8005208.0
2015-01-12 15:00:00	SPY	ETF	202.45	202.73	202.27	202.38	7337873.0
2015-01-12 15:30:00	SPY	ETF	202.38	203.05	202.0	202.62	19204958.0
2015-01-12 16:00:00	SPY	ETF	202.62	202.88	202.53	202.7	6619679.0
2015-01-12 16:30:00	SPY	ETF	202.71	202.8	202.69	202.8	4272311.0
2015-01-12 17:00:00	SPY	ETF	202.79	202.8	202.65	202.79	99242.0
2015-01-12 17:30:00	SPY	ETF	202.75	202.75	202.7	202.72	15958.0
2015-01-12 18:00:00	SPY	ETF	202.73	202.94	202.73	202.82	263796.0
2015-01-12 18:30:00	SPY	ETF	202.74	202.8	202.74	202.8	36940.0
2015-01-12 19:00:00	SPY	ETF	202.8	202.83	202.74	202.83	10680.0
2015-01-12 19:30:00	SPY	ETF	202.77	202.81	202.69	202.69	25045.0
2015-01-12 04:00:00	QQQ	ETF	102.82	102.9	102.65	102.65	28050.0
2015-01-12 04:30:00	QQQ	ETF	102.76	102.82	102.76	102.82	10100.0
2015-01-12 05:00:00	QQQ	ETF	103.01	103.01	103.01	103.01	800.0
2015-01-12 06:30:00	QQQ	ETF	103.04	103.15	103.04	103.15	5982.0
2015-01-12 07:00:00	QQQ	ETF	103.07	103.07	102.99	103.0	12568.0
2015-01-12 07:30:00	QQQ	ETF	103.08	103.1	102.92	102.93	43110.0
2015-01-12 08:00:00	QQQ	ETF	102.91	103.13	102.7	102.7	165187.0
2015-01-12 08:30:00	QQQ	ETF	102.72	102.78	102.62	102.75	108758.0
2015-01-12 09:00:00	QQQ	ETF	102.76	102.87	102.73	102.84	80381.0
2015-01-12 09:30:00	QQQ	ETF	102.82	102.93	101.54	101.64	4636317.0
2015-01-12 10:00:00	QQQ	ETF	101.65	101.83	101.32	101.54	3205818.0
2015-01-12 10:30:00	QQQ	ETF	101.525	102.05	101.45	102.05	2543095.0
2015-01-12 11:00:00	QQQ	ETF	102.04	102.1199	101.82	101.88	1498579.0
2015-01-12 11:30:00	QQQ	ETF	101.88	101.9542	101.61	101.735	1277123.0
2015-01-12 12:00:00	QQQ	ETF	101.75	102.03	101.736	101.901	882302.0
2015-01-12 12:30:00	QQQ	ETF	101.9	101.99	101.65	101.7	583964.0
2015-01-12 13:00:00	QQQ	ETF	101.7	101.8	101.46	101.47	1058593.0
2015-01-12 13:30:00	QQQ	ETF	101.47	101.77	101.465	101.7	599370.0

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

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