PREVIEW / etf_30min / 2017-11-28

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-11-28.parquet
  size:    453 KB
  rows:    15,563

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
2017-11-28 04:00:00	SPY	ETF	260.35	260.53	260.35	260.5	1929.0
2017-11-28 04:30:00	SPY	ETF	260.49	260.53	260.49	260.53	5700.0
2017-11-28 05:00:00	SPY	ETF	260.53	260.63	260.51	260.51	2500.0
2017-11-28 05:30:00	SPY	ETF	260.61	260.61	260.61	260.61	2000.0
2017-11-28 06:00:00	SPY	ETF	260.62	260.62	260.56	260.61	4452.0
2017-11-28 06:30:00	SPY	ETF	260.65	260.7	260.65	260.7	10581.0
2017-11-28 07:00:00	SPY	ETF	260.65	260.7	260.64	260.66	140268.0
2017-11-28 07:30:00	SPY	ETF	260.66	260.71	260.62	260.63	109535.0
2017-11-28 08:00:00	SPY	ETF	260.62	260.69	260.62	260.65	66237.0
2017-11-28 08:30:00	SPY	ETF	260.67	260.77	260.61	260.74	145763.0
2017-11-28 09:00:00	SPY	ETF	260.74	260.87	260.74	260.77	564448.0
2017-11-28 09:30:00	SPY	ETF	260.76	260.97	260.655	260.785	4843963.0
2017-11-28 10:00:00	SPY	ETF	260.79	261.1	260.7899	260.95	4800014.0
2017-11-28 10:30:00	SPY	ETF	260.94	261.18	260.94	261.09	2982822.0
2017-11-28 11:00:00	SPY	ETF	261.09	261.19	261.05	261.19	2218222.0
2017-11-28 11:30:00	SPY	ETF	261.18	261.57	261.14	261.55	3632490.0
2017-11-28 12:00:00	SPY	ETF	261.55	261.93	261.54	261.8585	4280579.0
2017-11-28 12:30:00	SPY	ETF	261.85	262.0299	261.75	261.97	5927980.0
2017-11-28 13:00:00	SPY	ETF	261.975	262.26	261.725	261.91	7849328.0
2017-11-28 13:30:00	SPY	ETF	261.91	262.01	261.37	261.42	5728942.0
2017-11-28 14:00:00	SPY	ETF	261.42	261.8099	261.17	261.8	6459722.0
2017-11-28 14:30:00	SPY	ETF	261.8	262.49	261.77	262.42	8045724.0
2017-11-28 15:00:00	SPY	ETF	262.42	262.9	262.34	262.62	9576192.0
2017-11-28 15:30:00	SPY	ETF	262.62	262.85	262.52	262.85	14691470.0
2017-11-28 16:00:00	SPY	ETF	262.84	262.87	262.74	262.8	12826176.0
2017-11-28 16:30:00	SPY	ETF	262.78	262.87	260.7594	262.76	1420870.0
2017-11-28 17:00:00	SPY	ETF	262.76	262.79	262.7	262.74	786354.0
2017-11-28 17:30:00	SPY	ETF	262.73	262.78	262.73	262.76	44742.0
2017-11-28 18:00:00	SPY	ETF	262.77	262.78	262.64	262.67	107175.0
2017-11-28 18:30:00	SPY	ETF	262.69	262.74	262.62	262.7	60919.0
2017-11-28 19:00:00	SPY	ETF	262.69	262.78	262.68	262.74	55280.0
2017-11-28 19:30:00	SPY	ETF	262.74	262.74	262.62	262.7	53102.0
2017-11-28 04:00:00	QQQ	ETF	156.31	156.31	156.23	156.23	1230.0
2017-11-28 04:30:00	QQQ	ETF	156.27	156.28	156.27	156.27	10000.0
2017-11-28 05:00:00	QQQ	ETF	156.29	156.29	156.29	156.29	200.0
2017-11-28 05:30:00	QQQ	ETF	156.33	156.37	156.32	156.37	4100.0
2017-11-28 06:00:00	QQQ	ETF	156.38	156.41	156.38	156.41	15000.0
2017-11-28 06:30:00	QQQ	ETF	156.37	156.4	156.37	156.4	1100.0
2017-11-28 07:00:00	QQQ	ETF	156.39	156.45	156.39	156.43	11100.0
2017-11-28 07:30:00	QQQ	ETF	156.42	156.42	156.42	156.42	2400.0
2017-11-28 08:00:00	QQQ	ETF	156.4	156.49	156.4	156.48	21007.0
2017-11-28 08:30:00	QQQ	ETF	156.48	156.5	156.42	156.48	14100.0
2017-11-28 09:00:00	QQQ	ETF	156.48	156.59	156.48	156.515	66969.0
2017-11-28 09:30:00	QQQ	ETF	156.52	156.56	156.22	156.28	1684310.0
2017-11-28 10:00:00	QQQ	ETF	156.28	156.48	156.25	156.37	1314655.0
2017-11-28 10:30:00	QQQ	ETF	156.37	156.47	156.19	156.25	812469.0
2017-11-28 11:00:00	QQQ	ETF	156.25	156.42	156.25	156.39	795837.0
2017-11-28 11:30:00	QQQ	ETF	156.39	156.56	156.34	156.47	859137.0
2017-11-28 12:00:00	QQQ	ETF	156.48	156.639	156.465	156.57	723627.0
2017-11-28 12:30:00	QQQ	ETF	156.57	156.6	156.4	156.48	425470.0

> showing 50 of 15,563 rows — these rows as CSV

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