PREVIEW / etf_30min / 2015-04-06

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-06.parquet
  size:    385 KB
  rows:    12,921

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-04-06 04:00:00	SPY	ETF	205.5	205.5	204.71	204.95	6375.0
2015-04-06 04:30:00	SPY	ETF	205.07	205.07	205.03	205.03	1200.0
2015-04-06 05:00:00	SPY	ETF	205.08	205.08	205.05	205.05	216.0
2015-04-06 05:30:00	SPY	ETF	205.0	205.0	204.95	204.95	750.0
2015-04-06 06:00:00	SPY	ETF	204.95	204.95	204.92	204.95	1700.0
2015-04-06 06:30:00	SPY	ETF	204.95	205.1	204.95	205.04	36050.0
2015-04-06 07:00:00	SPY	ETF	205.09	205.21	204.87	205.0	75058.0
2015-04-06 07:30:00	SPY	ETF	205.01	205.11	204.86	204.88	265415.0
2015-04-06 08:00:00	SPY	ETF	204.92	205.18	204.76	205.06	238145.0
2015-04-06 08:30:00	SPY	ETF	205.07	205.2	205.03	205.08	227988.0
2015-04-06 09:00:00	SPY	ETF	205.08	205.41	205.06	205.37	707667.0
2015-04-06 09:30:00	SPY	ETF	205.37	206.71	205.21	206.51	15245616.0
2015-04-06 10:00:00	SPY	ETF	206.51	207.49	206.49	207.45	9837071.0
2015-04-06 10:30:00	SPY	ETF	207.45	207.73	207.4	207.59	7092994.0
2015-04-06 11:00:00	SPY	ETF	207.6	207.845	207.57	207.74	5426910.0
2015-04-06 11:30:00	SPY	ETF	207.74	208.03	207.69	207.925	5402089.0
2015-04-06 12:00:00	SPY	ETF	207.925	208.27	207.905	208.14	6690100.0
2015-04-06 12:30:00	SPY	ETF	208.14	208.27	208.09	208.23	5140102.0
2015-04-06 13:00:00	SPY	ETF	208.23	208.42	208.22	208.41	5110846.0
2015-04-06 13:30:00	SPY	ETF	208.42	208.45	208.22	208.3	4896156.0
2015-04-06 14:00:00	SPY	ETF	208.295	208.33	208.12	208.25	6513624.0
2015-04-06 14:30:00	SPY	ETF	208.245	208.42	208.24	208.32	4568273.0
2015-04-06 15:00:00	SPY	ETF	208.33	208.4	208.01	208.03	6157841.0
2015-04-06 15:30:00	SPY	ETF	208.02	208.16	207.75	207.84	12580136.0
2015-04-06 16:00:00	SPY	ETF	207.83	207.9024	207.71	207.81	7501576.0
2015-04-06 16:30:00	SPY	ETF	207.79	207.81	207.28	207.72	9269235.0
2015-04-06 17:00:00	SPY	ETF	207.71	207.71	207.62	207.69	589162.0
2015-04-06 17:30:00	SPY	ETF	207.7	207.7	207.63	207.65	32950.0
2015-04-06 18:00:00	SPY	ETF	207.65	207.72	207.59	207.7	100866.0
2015-04-06 18:30:00	SPY	ETF	207.68	207.7	207.6	207.62	40937.0
2015-04-06 19:00:00	SPY	ETF	207.62	207.64	207.58	207.58	107140.0
2015-04-06 19:30:00	SPY	ETF	207.6	207.66	207.58	207.63	131387.0
2015-04-06 04:00:00	QQQ	ETF	104.36	104.36	104.12	104.3	1675.0
2015-04-06 05:00:00	QQQ	ETF	104.3	104.3	104.3	104.3	200.0
2015-04-06 06:30:00	QQQ	ETF	104.33	104.33	104.33	104.33	3400.0
2015-04-06 07:00:00	QQQ	ETF	104.37	104.42	104.28	104.28	6800.0
2015-04-06 07:30:00	QQQ	ETF	104.4	104.4	104.29	104.34	23325.0
2015-04-06 08:00:00	QQQ	ETF	104.38	104.42	104.34	104.42	104596.0
2015-04-06 08:30:00	QQQ	ETF	104.42	104.48	104.39	104.44	67201.0
2015-04-06 09:00:00	QQQ	ETF	104.44	104.55	104.43	104.49	154140.0
2015-04-06 09:30:00	QQQ	ETF	104.49	105.41	104.34	105.17	4972791.0
2015-04-06 10:00:00	QQQ	ETF	105.18	105.73	105.14	105.7	2374677.0
2015-04-06 10:30:00	QQQ	ETF	105.7	105.861	105.64	105.76	1604646.0
2015-04-06 11:00:00	QQQ	ETF	105.76	105.86	105.72	105.81	1178441.0
2015-04-06 11:30:00	QQQ	ETF	105.805	105.94	105.766	105.9051	909051.0
2015-04-06 12:00:00	QQQ	ETF	105.9	106.09	105.89	106.05	1290347.0
2015-04-06 12:30:00	QQQ	ETF	106.04	106.085	105.97	106.061	784268.0
2015-04-06 13:00:00	QQQ	ETF	106.08	106.25	106.08	106.23	882857.0
2015-04-06 13:30:00	QQQ	ETF	106.23	106.27	106.13	106.1801	704744.0
2015-04-06 14:00:00	QQQ	ETF	106.18	106.195	106.04	106.12	950490.0

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

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