PREVIEW / etf_30min / 2014-10-01

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-01.parquet
  size:    377 KB
  rows:    12,488

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-01 04:00:00	SPY	ETF	196.75	196.98	196.75	196.98	26459.0
2014-10-01 04:30:00	SPY	ETF	196.97	197.09	196.96	197.02	39285.0
2014-10-01 05:00:00	SPY	ETF	197.06	197.09	196.94	196.97	16588.0
2014-10-01 05:30:00	SPY	ETF	196.97	196.97	196.77	196.82	31120.0
2014-10-01 06:00:00	SPY	ETF	196.85	196.88	196.83	196.88	22562.0
2014-10-01 06:30:00	SPY	ETF	196.9	196.92	196.8	196.86	95285.0
2014-10-01 07:00:00	SPY	ETF	196.83	196.94	196.76	196.81	111811.0
2014-10-01 07:30:00	SPY	ETF	196.79	196.8	196.54	196.65	316244.0
2014-10-01 08:00:00	SPY	ETF	196.79	196.79	196.26	196.46	778513.0
2014-10-01 08:30:00	SPY	ETF	196.48	196.64	196.32	196.59	1217373.0
2014-10-01 09:00:00	SPY	ETF	196.58	196.85	196.53	196.71	1258187.0
2014-10-01 09:30:00	SPY	ETF	196.7	196.77	195.42	195.78	22845318.0
2014-10-01 10:00:00	SPY	ETF	195.78	195.83	195.16	195.695	16461958.0
2014-10-01 10:30:00	SPY	ETF	195.7	195.95	195.21	195.91	10086253.0
2014-10-01 11:00:00	SPY	ETF	195.8999	196.23	195.65	195.75	9706897.0
2014-10-01 11:30:00	SPY	ETF	195.75	195.81	195.41	195.61	6850784.0
2014-10-01 12:00:00	SPY	ETF	195.62	195.68	195.31	195.62	8158268.0
2014-10-01 12:30:00	SPY	ETF	195.6	195.61	194.95	195.07	8147874.0
2014-10-01 13:00:00	SPY	ETF	195.075	195.18	194.74	194.99	10156527.0
2014-10-01 13:30:00	SPY	ETF	194.99	194.99	194.3	194.355	10832797.0
2014-10-01 14:00:00	SPY	ETF	194.36	194.83	194.27	194.69	9566635.0
2014-10-01 14:30:00	SPY	ETF	194.69	195.45	194.18	194.22	7220528.0
2014-10-01 15:00:00	SPY	ETF	194.23	194.44	193.91	194.36	15727139.0
2014-10-01 15:30:00	SPY	ETF	194.35	194.91	194.3	194.34	27073020.0
2014-10-01 16:00:00	SPY	ETF	194.33	194.72	194.2	194.61	5571437.0
2014-10-01 16:30:00	SPY	ETF	194.61	194.7	194.37	194.67	2101622.0
2014-10-01 17:00:00	SPY	ETF	194.68	194.69	194.54	194.63	291905.0
2014-10-01 17:30:00	SPY	ETF	194.6	194.64	194.59	194.63	32406.0
2014-10-01 18:00:00	SPY	ETF	194.65	194.71	194.63	194.68	37698.0
2014-10-01 18:30:00	SPY	ETF	194.7	194.72	194.62	194.63	37280.0
2014-10-01 19:00:00	SPY	ETF	194.64	194.7	194.64	194.64	23003.0
2014-10-01 19:30:00	SPY	ETF	194.62	194.66	194.6	194.64	85110.0
2014-10-01 06:00:00	QQQ	ETF	98.66	98.66	98.65	98.65	10100.0
2014-10-01 06:30:00	QQQ	ETF	98.68	98.71	98.66	98.71	2200.0
2014-10-01 07:00:00	QQQ	ETF	98.62	98.69	98.61	98.65	23600.0
2014-10-01 07:30:00	QQQ	ETF	98.58	98.59	98.5	98.55	27550.0
2014-10-01 08:00:00	QQQ	ETF	98.68	98.68	98.41	98.49	320505.0
2014-10-01 08:30:00	QQQ	ETF	98.49	98.57	98.41	98.54	105044.0
2014-10-01 09:00:00	QQQ	ETF	98.53	98.64	98.48	98.55	293967.0
2014-10-01 09:30:00	QQQ	ETF	98.54	98.61	97.89	97.96	7537516.0
2014-10-01 10:00:00	QQQ	ETF	97.96	98.019	97.54	97.81	6785458.0
2014-10-01 10:30:00	QQQ	ETF	97.82	97.89	97.55	97.857	4880925.0
2014-10-01 11:00:00	QQQ	ETF	97.86	98.08	97.78	97.87	3266259.0
2014-10-01 11:30:00	QQQ	ETF	97.86	97.91	97.67	97.8	1934302.0
2014-10-01 12:00:00	QQQ	ETF	97.79	97.8	97.59	97.8	1930971.0
2014-10-01 12:30:00	QQQ	ETF	97.79	97.8	97.4	97.47	2831916.0
2014-10-01 13:00:00	QQQ	ETF	97.47	97.54	97.34	97.45	2603191.0
2014-10-01 13:30:00	QQQ	ETF	97.46	97.46	97.05	97.09	3076542.0
2014-10-01 14:00:00	QQQ	ETF	97.1	97.42	97.05	97.3	2855909.0
2014-10-01 14:30:00	QQQ	ETF	97.3	97.34	97.03	97.06	2760586.0

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

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