PREVIEW / etf_30min / 2015-09-24

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-09-24.parquet
  size:    388 KB
  rows:    13,043

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-09-24 04:00:00	SPY	ETF	193.37	194.37	193.37	194.1	17350.0
2015-09-24 04:30:00	SPY	ETF	194.08	194.08	193.72	193.77	5300.0
2015-09-24 05:00:00	SPY	ETF	193.9	193.9	193.19	193.37	13370.0
2015-09-24 05:30:00	SPY	ETF	193.3	193.4	193.0	193.25	6681.0
2015-09-24 06:00:00	SPY	ETF	193.28	193.32	192.63	192.64	51769.0
2015-09-24 06:30:00	SPY	ETF	192.63	192.65	192.09	192.43	200960.0
2015-09-24 07:00:00	SPY	ETF	192.42	192.43	191.68	191.87	398475.0
2015-09-24 07:30:00	SPY	ETF	191.84	192.3	191.84	192.15	466213.0
2015-09-24 08:00:00	SPY	ETF	192.17	192.9792	191.7	191.95	823306.0
2015-09-24 08:30:00	SPY	ETF	191.96	192.29	191.65	192.16	753099.0
2015-09-24 09:00:00	SPY	ETF	192.16	192.17	191.77	192.15	1063481.0
2015-09-24 09:30:00	SPY	ETF	192.15	192.43	191.08	191.42	15273647.0
2015-09-24 10:00:00	SPY	ETF	191.43	191.79	190.95	191.05	13633463.0
2015-09-24 10:30:00	SPY	ETF	191.04	191.4	190.76	190.86	11076819.0
2015-09-24 11:00:00	SPY	ETF	190.8601	191.21	190.56	190.87	12119315.0
2015-09-24 11:30:00	SPY	ETF	190.87	191.54	190.84	191.45	7571439.0
2015-09-24 12:00:00	SPY	ETF	191.46	191.79	191.36	191.72	6068176.0
2015-09-24 12:30:00	SPY	ETF	191.7299	192.2	191.309	191.31	8436180.0
2015-09-24 13:00:00	SPY	ETF	191.3	191.6475	191.04	191.29	6262065.0
2015-09-24 13:30:00	SPY	ETF	191.3	191.91	191.14	191.67	5932568.0
2015-09-24 14:00:00	SPY	ETF	191.66	192.5	191.48	192.34	8768494.0
2015-09-24 14:30:00	SPY	ETF	192.34	193.45	192.08	193.12	14953794.0
2015-09-24 15:00:00	SPY	ETF	193.13	193.41	192.23	193.23	13876027.0
2015-09-24 15:30:00	SPY	ETF	193.23	193.36	192.56	192.93	16587129.0
2015-09-24 16:00:00	SPY	ETF	192.93	193.07	192.54	192.84	5646313.0
2015-09-24 16:30:00	SPY	ETF	192.87	193.0	192.67	192.74	2489223.0
2015-09-24 17:00:00	SPY	ETF	192.75	192.84	192.43	192.76	286806.0
2015-09-24 17:30:00	SPY	ETF	192.75	192.85	192.22	192.25	168752.0
2015-09-24 18:00:00	SPY	ETF	192.27	193.09	192.2	193.02	454693.0
2015-09-24 18:30:00	SPY	ETF	193.03	193.52	193.0	193.26	139255.0
2015-09-24 19:00:00	SPY	ETF	193.25	193.31	192.8	193.01	93410.0
2015-09-24 19:30:00	SPY	ETF	193.01	193.31	192.94	193.27	48098.0
2015-09-24 04:00:00	QQQ	ETF	103.89	103.89	103.89	103.89	500.0
2015-09-24 04:30:00	QQQ	ETF	104.28	104.28	104.15	104.19	7200.0
2015-09-24 05:00:00	QQQ	ETF	104.22	104.27	103.83	103.87	3411.0
2015-09-24 05:30:00	QQQ	ETF	103.9	103.9	103.73	103.83	19900.0
2015-09-24 06:00:00	QQQ	ETF	103.86	103.89	103.51	103.51	10260.0
2015-09-24 06:30:00	QQQ	ETF	103.53	103.53	103.2	103.38	18950.0
2015-09-24 07:00:00	QQQ	ETF	103.28	103.28	102.78	102.92	48807.0
2015-09-24 07:30:00	QQQ	ETF	102.96	103.15	102.96	103.08	21608.0
2015-09-24 08:00:00	QQQ	ETF	103.13	103.21	102.85	102.99	107304.0
2015-09-24 08:30:00	QQQ	ETF	103.01	103.29	102.86	103.2	214573.0
2015-09-24 09:00:00	QQQ	ETF	103.21	103.21	102.99	103.17	214202.0
2015-09-24 09:30:00	QQQ	ETF	103.17	103.45	102.64	102.91	5138901.0
2015-09-24 10:00:00	QQQ	ETF	102.92	103.1	102.5801	102.6351	3178134.0
2015-09-24 10:30:00	QQQ	ETF	102.63	102.8	102.36	102.485	2215875.0
2015-09-24 11:00:00	QQQ	ETF	102.48	102.7	102.27	102.43	2476910.0
2015-09-24 11:30:00	QQQ	ETF	102.44	102.79	102.43	102.7482	1856681.0
2015-09-24 12:00:00	QQQ	ETF	102.73	102.98	102.67	102.9631	1059077.0
2015-09-24 12:30:00	QQQ	ETF	102.97	103.27	102.75	102.76	1707020.0

> showing 50 of 13,043 rows — these rows as CSV

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