PREVIEW / etf_30min / 2013-10-30

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-30.parquet
  size:    330 KB
  rows:    11,129

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-30 04:00:00	SPY	ETF	177.22	177.63	177.22	177.56	173400.0
2013-10-30 04:30:00	SPY	ETF	177.56	177.62	177.54	177.61	101050.0
2013-10-30 05:00:00	SPY	ETF	177.62	177.7	177.61	177.68	101610.0
2013-10-30 05:30:00	SPY	ETF	177.7	177.76	177.7	177.75	117700.0
2013-10-30 06:00:00	SPY	ETF	177.7	177.7	177.64	177.66	24500.0
2013-10-30 06:30:00	SPY	ETF	177.67	177.7	177.65	177.66	5700.0
2013-10-30 07:00:00	SPY	ETF	177.7	177.7	177.62	177.65	24140.0
2013-10-30 07:30:00	SPY	ETF	177.64	177.65	177.56	177.62	75248.0
2013-10-30 08:00:00	SPY	ETF	177.61	177.75	177.44	177.54	500115.0
2013-10-30 08:30:00	SPY	ETF	177.53	177.58	177.39	177.44	405705.0
2013-10-30 09:00:00	SPY	ETF	177.44	177.49	177.28	177.38	523397.0
2013-10-30 09:30:00	SPY	ETF	177.38	177.51	177.13	177.27	10060058.0
2013-10-30 10:00:00	SPY	ETF	177.265	177.34	177.02	177.195	8012539.0
2013-10-30 10:30:00	SPY	ETF	177.2	177.32	177.04	177.25	7128997.0
2013-10-30 11:00:00	SPY	ETF	177.25	177.31	176.85	176.86	6687252.0
2013-10-30 11:30:00	SPY	ETF	176.8611	176.869	176.65	176.7303	6549500.0
2013-10-30 12:00:00	SPY	ETF	176.73	176.86	176.69	176.741	3761514.0
2013-10-30 12:30:00	SPY	ETF	176.74	176.99	176.74	176.9625	3370934.0
2013-10-30 13:00:00	SPY	ETF	176.96	176.99	176.69	176.69	4011346.0
2013-10-30 13:30:00	SPY	ETF	176.695	176.77	176.52	176.63	5203524.0
2013-10-30 14:00:00	SPY	ETF	176.64	177.07	175.66	175.97	29006535.0
2013-10-30 14:30:00	SPY	ETF	175.96	176.35	175.85	176.2686	12145117.0
2013-10-30 15:00:00	SPY	ETF	176.26	176.59	176.14	176.36	11023850.0
2013-10-30 15:30:00	SPY	ETF	176.37	176.59	176.23	176.345	14174064.0
2013-10-30 16:00:00	SPY	ETF	176.345	177.1	176.23	176.55	8375852.0
2013-10-30 16:30:00	SPY	ETF	176.55	176.56	176.44	176.44	1430021.0
2013-10-30 17:00:00	SPY	ETF	176.44	176.45	176.29	176.34	5202353.0
2013-10-30 17:30:00	SPY	ETF	176.35	176.37	176.27	176.27	70012.0
2013-10-30 18:00:00	SPY	ETF	176.27	176.29	176.04	176.07	119164.0
2013-10-30 18:30:00	SPY	ETF	176.07	176.12	175.84	175.87	72113.0
2013-10-30 19:00:00	SPY	ETF	175.87	175.95	175.85	175.89	59514.0
2013-10-30 19:30:00	SPY	ETF	175.89	175.99	175.82	175.96	95350.0
2013-10-30 04:00:00	QQQ	ETF	83.23	83.32	83.22	83.32	30000.0
2013-10-30 04:30:00	QQQ	ETF	83.33	83.35	83.32	83.35	8600.0
2013-10-30 05:00:00	QQQ	ETF	83.36	83.4	83.36	83.39	6300.0
2013-10-30 05:30:00	QQQ	ETF	83.4	83.43	83.4	83.41	5500.0
2013-10-30 06:00:00	QQQ	ETF	83.4	83.4	83.37	83.38	2100.0
2013-10-30 06:30:00	QQQ	ETF	83.39	83.42	83.39	83.39	4275.0
2013-10-30 07:00:00	QQQ	ETF	83.4	83.44	83.4	83.43	15600.0
2013-10-30 07:30:00	QQQ	ETF	83.42	83.44	83.41	83.43	29900.0
2013-10-30 08:00:00	QQQ	ETF	83.43	83.44	83.35	83.4	134754.0
2013-10-30 08:30:00	QQQ	ETF	83.39	83.41	83.31	83.34	66572.0
2013-10-30 09:00:00	QQQ	ETF	83.33	83.36	83.06	83.34	309548.0
2013-10-30 09:30:00	QQQ	ETF	83.35	83.485	83.28	83.37	3672191.0
2013-10-30 10:00:00	QQQ	ETF	83.375	83.39	83.081	83.23	3120474.0
2013-10-30 10:30:00	QQQ	ETF	83.23	83.33	83.151	83.3	1509820.0
2013-10-30 11:00:00	QQQ	ETF	83.31	83.375	83.15	83.16	1765923.0
2013-10-30 11:30:00	QQQ	ETF	83.15	83.16	82.94	83.03	2121717.0
2013-10-30 12:00:00	QQQ	ETF	83.03	83.12	82.96	83.01	831048.0
2013-10-30 12:30:00	QQQ	ETF	83.01	83.17	82.98	83.17	990177.0

> showing 50 of 11,129 rows — these rows as CSV

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