PREVIEW / etf_30min / 2015-01-08

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-01-08.parquet
  size:    381 KB
  rows:    12,875

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-08 04:00:00	SPY	ETF	203.0	203.73	203.0	203.61	13877.0
2015-01-08 04:30:00	SPY	ETF	203.61	203.65	203.57	203.61	1500.0
2015-01-08 05:00:00	SPY	ETF	203.61	203.75	203.55	203.55	115512.0
2015-01-08 05:30:00	SPY	ETF	203.56	203.7	203.52	203.7	9064.0
2015-01-08 06:00:00	SPY	ETF	203.7	204.13	203.64	204.0	215852.0
2015-01-08 06:30:00	SPY	ETF	204.04	204.22	203.95	204.05	381933.0
2015-01-08 07:00:00	SPY	ETF	204.1	204.42	204.01	204.26	355259.0
2015-01-08 07:30:00	SPY	ETF	204.26	204.32	203.95	204.0	474890.0
2015-01-08 08:00:00	SPY	ETF	203.99	204.37	203.56	203.89	575106.0
2015-01-08 08:30:00	SPY	ETF	203.89	204.1	203.76	203.87	592390.0
2015-01-08 09:00:00	SPY	ETF	203.88	204.05	203.82	204.0	722893.0
2015-01-08 09:30:00	SPY	ETF	204.01	204.82	203.99	204.81	17473620.0
2015-01-08 10:00:00	SPY	ETF	204.805	205.25	204.8	205.05	14167721.0
2015-01-08 10:30:00	SPY	ETF	205.04	205.49	204.97	205.49	9060827.0
2015-01-08 11:00:00	SPY	ETF	205.49	205.81	205.46	205.51	10760597.0
2015-01-08 11:30:00	SPY	ETF	205.505	205.68	205.43	205.62	6267265.0
2015-01-08 12:00:00	SPY	ETF	205.63	205.64	205.21	205.44	4524418.0
2015-01-08 12:30:00	SPY	ETF	205.45	205.72	205.43	205.66	3421848.0
2015-01-08 13:00:00	SPY	ETF	205.66	205.95	205.56	205.845	6981563.0
2015-01-08 13:30:00	SPY	ETF	205.85	205.92	205.36	205.46	5536866.0
2015-01-08 14:00:00	SPY	ETF	205.46	205.87	205.35	205.84	7405602.0
2015-01-08 14:30:00	SPY	ETF	205.85	206.16	205.845	205.92	14637774.0
2015-01-08 15:00:00	SPY	ETF	205.915	206.13	205.5724	206.045	11125333.0
2015-01-08 15:30:00	SPY	ETF	206.05	206.06	205.62	205.92	20161632.0
2015-01-08 16:00:00	SPY	ETF	205.92	205.96	205.68	205.77	6326144.0
2015-01-08 16:30:00	SPY	ETF	205.77	205.94	205.68	205.7	2204702.0
2015-01-08 17:00:00	SPY	ETF	205.71	205.8	205.68	205.74	191378.0
2015-01-08 17:30:00	SPY	ETF	205.74	205.77	205.71	205.74	25146.0
2015-01-08 18:00:00	SPY	ETF	205.75	205.77	205.68	205.69	38864.0
2015-01-08 18:30:00	SPY	ETF	205.7	205.78	205.69	205.74	13495.0
2015-01-08 19:00:00	SPY	ETF	205.74	205.74	205.64	205.68	60250.0
2015-01-08 19:30:00	SPY	ETF	205.69	205.75	205.69	205.73	39237.0
2015-01-08 04:00:00	QQQ	ETF	101.75	102.35	101.75	102.14	8450.0
2015-01-08 05:00:00	QQQ	ETF	102.05	102.05	102.05	102.05	300.0
2015-01-08 06:00:00	QQQ	ETF	102.13	102.29	102.13	102.24	3700.0
2015-01-08 06:30:00	QQQ	ETF	102.24	102.3	102.2	102.22	31450.0
2015-01-08 07:00:00	QQQ	ETF	102.3	102.39	102.3	102.34	25992.0
2015-01-08 07:30:00	QQQ	ETF	102.33	102.33	102.22	102.22	35088.0
2015-01-08 08:00:00	QQQ	ETF	102.2	102.36	102.1	102.14	82817.0
2015-01-08 08:30:00	QQQ	ETF	102.16	102.18	102.07	102.12	65530.0
2015-01-08 09:00:00	QQQ	ETF	102.14	102.22	102.08	102.21	385607.0
2015-01-08 09:30:00	QQQ	ETF	102.22	102.665	102.111	102.66	5312352.0
2015-01-08 10:00:00	QQQ	ETF	102.67	102.959	102.65	102.8399	3844351.0
2015-01-08 10:30:00	QQQ	ETF	102.84	103.19	102.76	103.19	3479555.0
2015-01-08 11:00:00	QQQ	ETF	103.2	103.36	103.06	103.11	3848625.0
2015-01-08 11:30:00	QQQ	ETF	103.11	103.26	103.1	103.21	1647326.0
2015-01-08 12:00:00	QQQ	ETF	103.215	103.245	102.9807	103.16	1560412.0
2015-01-08 12:30:00	QQQ	ETF	103.17	103.33	103.14	103.3	1683449.0
2015-01-08 13:00:00	QQQ	ETF	103.3	103.5	103.25	103.4499	1766449.0
2015-01-08 13:30:00	QQQ	ETF	103.44	103.5	103.2	103.25	1498853.0

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

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