PREVIEW / etf_30min / 2015-04-14

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-14.parquet
  size:    373 KB
  rows:    12,549

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-14 04:00:00	SPY	ETF	209.58	209.73	209.39	209.66	5830.0
2015-04-14 04:30:00	SPY	ETF	209.59	209.63	209.21	209.21	7900.0
2015-04-14 05:00:00	SPY	ETF	209.14	209.14	208.46	208.47	28272.0
2015-04-14 05:30:00	SPY	ETF	208.64	208.74	208.64	208.74	7465.0
2015-04-14 06:00:00	SPY	ETF	208.69	209.0	208.69	209.0	11851.0
2015-04-14 06:30:00	SPY	ETF	209.02	209.02	208.8	208.82	56900.0
2015-04-14 07:00:00	SPY	ETF	208.82	209.17	208.79	209.13	184440.0
2015-04-14 07:30:00	SPY	ETF	209.14	209.14	208.87	208.89	122410.0
2015-04-14 08:00:00	SPY	ETF	208.89	209.77	208.87	209.04	233620.0
2015-04-14 08:30:00	SPY	ETF	209.04	209.08	208.73	209.0	769833.0
2015-04-14 09:00:00	SPY	ETF	208.99	208.99	208.62	208.84	1058449.0
2015-04-14 09:30:00	SPY	ETF	208.85	209.5	208.56	208.73	10705108.0
2015-04-14 10:00:00	SPY	ETF	208.73	208.73	208.1	208.56	12465751.0
2015-04-14 10:30:00	SPY	ETF	208.56	208.75	208.14	208.575	4544952.0
2015-04-14 11:00:00	SPY	ETF	208.58	209.33	208.42	209.02	6886323.0
2015-04-14 11:30:00	SPY	ETF	209.02	209.2	208.95	209.19	3608485.0
2015-04-14 12:00:00	SPY	ETF	209.2	209.4	209.15	209.355	2084406.0
2015-04-14 12:30:00	SPY	ETF	209.3555	209.71	209.3555	209.41	4178641.0
2015-04-14 13:00:00	SPY	ETF	209.41	209.45	209.23	209.35	1604605.0
2015-04-14 13:30:00	SPY	ETF	209.35	209.475	209.23	209.355	1562750.0
2015-04-14 14:00:00	SPY	ETF	209.35	209.4	209.23	209.36	2415223.0
2015-04-14 14:30:00	SPY	ETF	209.37	209.42	209.09	209.37	2705968.0
2015-04-14 15:00:00	SPY	ETF	209.37	209.58	209.33	209.4	5357765.0
2015-04-14 15:30:00	SPY	ETF	209.39	209.6	209.19	209.48	8526853.0
2015-04-14 16:00:00	SPY	ETF	209.48	209.64	209.3137	209.61	3068819.0
2015-04-14 16:30:00	SPY	ETF	209.61	209.7	209.41	209.62	1539562.0
2015-04-14 17:00:00	SPY	ETF	209.62	209.67	209.61	209.66	54499.0
2015-04-14 17:30:00	SPY	ETF	209.63	209.68	209.63	209.66	5280.0
2015-04-14 18:00:00	SPY	ETF	209.67	209.68	209.58	209.61	24577.0
2015-04-14 18:30:00	SPY	ETF	209.61	209.66	209.61	209.66	66250.0
2015-04-14 19:00:00	SPY	ETF	209.62	209.63	209.52	209.53	58783.0
2015-04-14 19:30:00	SPY	ETF	209.53	209.58	209.52	209.55	152866.0
2015-04-14 05:00:00	QQQ	ETF	107.24	107.24	107.04	107.04	300.0
2015-04-14 05:30:00	QQQ	ETF	107.12	107.12	107.12	107.12	200.0
2015-04-14 06:00:00	QQQ	ETF	107.25	107.27	107.23	107.27	18100.0
2015-04-14 06:30:00	QQQ	ETF	107.26	107.26	107.23	107.24	1700.0
2015-04-14 07:00:00	QQQ	ETF	107.26	107.49	107.23	107.44	34200.0
2015-04-14 07:30:00	QQQ	ETF	107.45	107.47	107.34	107.35	10758.0
2015-04-14 08:00:00	QQQ	ETF	107.35	107.51	107.34	107.42	27642.0
2015-04-14 08:30:00	QQQ	ETF	107.4	107.5	107.29	107.48	86936.0
2015-04-14 09:00:00	QQQ	ETF	107.46	107.46	107.25	107.36	146028.0
2015-04-14 09:30:00	QQQ	ETF	107.37	107.68	106.87	106.96	5267884.0
2015-04-14 10:00:00	QQQ	ETF	106.96	107.04	106.62	106.891	2866878.0
2015-04-14 10:30:00	QQQ	ETF	106.89	106.89	106.56	106.755	2040862.0
2015-04-14 11:00:00	QQQ	ETF	106.75	107.11	106.66	106.93	2176279.0
2015-04-14 11:30:00	QQQ	ETF	106.94	107.02	106.8	106.925	1029392.0
2015-04-14 12:00:00	QQQ	ETF	106.93	107.1	106.91	107.06	962431.0
2015-04-14 12:30:00	QQQ	ETF	107.06	107.32	107.05	107.06	1461607.0
2015-04-14 13:00:00	QQQ	ETF	107.06	107.08	106.9	107.02	918705.0
2015-04-14 13:30:00	QQQ	ETF	107.03	107.07	106.95	107.0	606630.0

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

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