PREVIEW / etf_30min / 2013-10-09

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-09.parquet
  size:    327 KB
  rows:    10,830

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
2013-10-09 04:00:00	SPY	ETF	165.98	166.12	165.91	165.95	26278.0
2013-10-09 04:30:00	SPY	ETF	165.93	166.08	165.91	166.08	13335.0
2013-10-09 05:00:00	SPY	ETF	166.09	166.29	166.09	166.27	14700.0
2013-10-09 05:30:00	SPY	ETF	166.23	166.23	166.07	166.07	3219.0
2013-10-09 06:00:00	SPY	ETF	166.05	166.18	166.05	166.09	37479.0
2013-10-09 06:30:00	SPY	ETF	166.09	166.18	166.05	166.12	32625.0
2013-10-09 07:00:00	SPY	ETF	166.15	166.26	166.08	166.14	192592.0
2013-10-09 07:30:00	SPY	ETF	166.11	166.11	165.9	165.9	457953.0
2013-10-09 08:00:00	SPY	ETF	166.25	166.25	165.7	166.0	493611.0
2013-10-09 08:30:00	SPY	ETF	165.99	166.02	165.78	165.83	464562.0
2013-10-09 09:00:00	SPY	ETF	165.83	166.0	165.77	165.81	695173.0
2013-10-09 09:30:00	SPY	ETF	165.8	165.82	165.175	165.62	16869859.0
2013-10-09 10:00:00	SPY	ETF	165.6199	165.7501	165.2	165.6438	12614708.0
2013-10-09 10:30:00	SPY	ETF	165.64	165.79	164.97	165.0	11197233.0
2013-10-09 11:00:00	SPY	ETF	165.01	165.25	164.53	164.785	11047539.0
2013-10-09 11:30:00	SPY	ETF	164.785	165.26	164.76	165.17	8552104.0
2013-10-09 12:00:00	SPY	ETF	165.18	165.36	165.07	165.1201	9608620.0
2013-10-09 12:30:00	SPY	ETF	165.13	165.41	164.99	165.06	5159043.0
2013-10-09 13:00:00	SPY	ETF	165.06	165.98	165.06	165.85	10794271.0
2013-10-09 13:30:00	SPY	ETF	165.86	166.0	165.69	165.8775	7965525.0
2013-10-09 14:00:00	SPY	ETF	165.87	166.1	165.65	165.97	15661396.0
2013-10-09 14:30:00	SPY	ETF	165.97	166.2	165.86	166.15	7742050.0
2013-10-09 15:00:00	SPY	ETF	166.16	166.2	165.82	165.95	6587388.0
2013-10-09 15:30:00	SPY	ETF	165.95	166.17	165.365	165.58	24654461.0
2013-10-09 16:00:00	SPY	ETF	165.56	166.03	165.3	165.33	6178563.0
2013-10-09 16:30:00	SPY	ETF	165.33	165.46	165.29	165.4	3005460.0
2013-10-09 17:00:00	SPY	ETF	165.39	165.4	165.28	165.31	1114913.0
2013-10-09 17:30:00	SPY	ETF	165.31	165.39	165.3	165.35	67754.0
2013-10-09 18:00:00	SPY	ETF	165.36	165.71	165.32	165.7	239294.0
2013-10-09 18:30:00	SPY	ETF	165.7	165.83	165.64	165.83	281770.0
2013-10-09 19:00:00	SPY	ETF	165.83	165.86	165.76	165.78	113970.0
2013-10-09 19:30:00	SPY	ETF	165.78	165.79	165.68	165.72	79849.0
2013-10-09 04:00:00	QQQ	ETF	77.22	77.6	77.22	77.51	26300.0
2013-10-09 04:30:00	QQQ	ETF	77.5	77.6	77.49	77.59	12130.0
2013-10-09 05:00:00	QQQ	ETF	77.6	77.65	77.59	77.65	4900.0
2013-10-09 05:30:00	QQQ	ETF	77.65	77.65	77.57	77.57	5950.0
2013-10-09 06:00:00	QQQ	ETF	77.58	77.62	77.55	77.56	10000.0
2013-10-09 06:30:00	QQQ	ETF	77.57	77.62	77.57	77.6	6600.0
2013-10-09 07:00:00	QQQ	ETF	77.6	77.63	77.55	77.58	21250.0
2013-10-09 07:30:00	QQQ	ETF	77.58	77.58	77.49	77.51	24590.0
2013-10-09 08:00:00	QQQ	ETF	77.51	77.59	77.42	77.55	54897.0
2013-10-09 08:30:00	QQQ	ETF	77.54	77.54	77.48	77.49	21247.0
2013-10-09 09:00:00	QQQ	ETF	77.49	77.54	77.22	77.42	142319.0
2013-10-09 09:30:00	QQQ	ETF	77.41	77.44	76.84	77.07	5599610.0
2013-10-09 10:00:00	QQQ	ETF	77.075	77.14	76.7	77.1	5473459.0
2013-10-09 10:30:00	QQQ	ETF	77.1	77.2	76.7199	76.73	3434389.0
2013-10-09 11:00:00	QQQ	ETF	76.73	76.82	76.35	76.51	4402603.0
2013-10-09 11:30:00	QQQ	ETF	76.52	76.72	76.46	76.59	4502236.0
2013-10-09 12:00:00	QQQ	ETF	76.59	76.76	76.53	76.6299	2393136.0
2013-10-09 12:30:00	QQQ	ETF	76.62	76.779	76.45	76.52	3935344.0

> showing 50 of 10,830 rows — these rows as CSV

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