PREVIEW / etf_30min / 2013-10-10

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-10.parquet
  size:    340 KB
  rows:    11,138

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-10 04:00:00	SPY	ETF	166.43	166.8	166.43	166.66	68372.0
2013-10-10 04:30:00	SPY	ETF	166.65	166.71	166.62	166.66	12411.0
2013-10-10 05:00:00	SPY	ETF	166.65	166.79	166.65	166.7	14710.0
2013-10-10 05:30:00	SPY	ETF	166.71	166.86	166.67	166.79	39773.0
2013-10-10 06:00:00	SPY	ETF	166.77	166.95	166.77	166.85	105721.0
2013-10-10 06:30:00	SPY	ETF	166.85	167.08	166.85	167.0	128796.0
2013-10-10 07:00:00	SPY	ETF	167.0	167.12	166.9	167.04	443975.0
2013-10-10 07:30:00	SPY	ETF	167.04	167.06	166.83	166.84	244455.0
2013-10-10 08:00:00	SPY	ETF	166.84	167.07	165.87	166.73	864971.0
2013-10-10 08:30:00	SPY	ETF	166.71	167.08	165.57	167.07	2212598.0
2013-10-10 09:00:00	SPY	ETF	167.07	167.33	167.07	167.28	2303733.0
2013-10-10 09:30:00	SPY	ETF	167.29	167.9	167.23	167.815	22872695.0
2013-10-10 10:00:00	SPY	ETF	167.815	167.97	167.62	167.85	11338681.0
2013-10-10 10:30:00	SPY	ETF	167.85	168.18	167.75	167.89	14234616.0
2013-10-10 11:00:00	SPY	ETF	167.88	167.96	167.59	167.94	11548018.0
2013-10-10 11:30:00	SPY	ETF	167.95	168.52	167.8	168.385	13740292.0
2013-10-10 12:00:00	SPY	ETF	168.3801	168.46	168.3	168.38	6977708.0
2013-10-10 12:30:00	SPY	ETF	168.38	168.51	168.37	168.41	4032662.0
2013-10-10 13:00:00	SPY	ETF	168.39	168.415	168.21	168.24	7036358.0
2013-10-10 13:30:00	SPY	ETF	168.25	168.46	168.19	168.43	7230947.0
2013-10-10 14:00:00	SPY	ETF	168.425	168.43	168.12	168.21	5969352.0
2013-10-10 14:30:00	SPY	ETF	168.22	168.38	168.16	168.37	4695395.0
2013-10-10 15:00:00	SPY	ETF	168.37	169.26	168.37	169.04	19325897.0
2013-10-10 15:30:00	SPY	ETF	169.04	169.19	168.82	169.16	30277940.0
2013-10-10 16:00:00	SPY	ETF	169.16	169.24	165.586	168.98	11812333.0
2013-10-10 16:30:00	SPY	ETF	168.98	169.1982	165.586	168.78	7977026.0
2013-10-10 17:00:00	SPY	ETF	168.78	168.85	168.67	168.82	2212361.0
2013-10-10 17:30:00	SPY	ETF	168.81	168.82	168.73	168.8	1553373.0
2013-10-10 18:00:00	SPY	ETF	168.8	168.86	167.86	168.22	1308606.0
2013-10-10 18:30:00	SPY	ETF	168.21	168.74	168.2	168.6	349383.0
2013-10-10 19:00:00	SPY	ETF	168.61	168.8	168.54	168.77	206124.0
2013-10-10 19:30:00	SPY	ETF	168.77	168.9	168.6	168.75	69452.0
2013-10-10 04:00:00	QQQ	ETF	77.37	77.48	77.35	77.43	33100.0
2013-10-10 04:30:00	QQQ	ETF	77.44	77.46	77.44	77.46	7200.0
2013-10-10 05:00:00	QQQ	ETF	77.47	77.51	77.47	77.48	4200.0
2013-10-10 05:30:00	QQQ	ETF	77.49	77.53	77.48	77.51	7600.0
2013-10-10 06:00:00	QQQ	ETF	77.52	77.58	77.52	77.54	7400.0
2013-10-10 06:30:00	QQQ	ETF	77.54	77.64	77.54	77.59	10500.0
2013-10-10 07:00:00	QQQ	ETF	77.6	77.67	77.6	77.65	83930.0
2013-10-10 07:30:00	QQQ	ETF	77.66	77.66	77.59	77.59	20030.0
2013-10-10 08:00:00	QQQ	ETF	77.6	77.66	77.54	77.55	71678.0
2013-10-10 08:30:00	QQQ	ETF	77.55	77.7	76.98	77.7	134890.0
2013-10-10 09:00:00	QQQ	ETF	77.71	77.86	77.71	77.79	294326.0
2013-10-10 09:30:00	QQQ	ETF	77.8	78.25	77.79	78.21	9010623.0
2013-10-10 10:00:00	QQQ	ETF	78.21	78.23	78.01	78.19	3910145.0
2013-10-10 10:30:00	QQQ	ETF	78.2	78.331	78.12	78.14	3378692.0
2013-10-10 11:00:00	QQQ	ETF	78.14	78.21	78.03	78.21	3428770.0
2013-10-10 11:30:00	QQQ	ETF	78.21	78.49	78.13	78.4399	3231120.0
2013-10-10 12:00:00	QQQ	ETF	78.44	78.47	78.39	78.46	1272732.0
2013-10-10 12:30:00	QQQ	ETF	78.467	78.55	78.46	78.48	1145029.0

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

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