PREVIEW / etf_30min / 2011-01-12

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-01-12.parquet
  size:    279 KB
  rows:    9,400

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
2011-01-12 04:00:00	SPY	ETF	127.92	128.14	127.92	128.14	7600.0
2011-01-12 04:30:00	SPY	ETF	128.25	128.33	128.25	128.33	21300.0
2011-01-12 05:00:00	SPY	ETF	128.35	128.36	128.23	128.23	2200.0
2011-01-12 05:30:00	SPY	ETF	128.24	128.24	128.17	128.17	2900.0
2011-01-12 06:00:00	SPY	ETF	128.12	128.2	128.12	128.2	1250.0
2011-01-12 06:30:00	SPY	ETF	128.14	128.18	128.0	128.12	58500.0
2011-01-12 07:00:00	SPY	ETF	128.16	128.2	128.1	128.13	113824.0
2011-01-12 07:30:00	SPY	ETF	128.1	128.21	128.07	128.18	407443.0
2011-01-12 08:00:00	SPY	ETF	128.18	128.26	127.62	128.19	1597750.0
2011-01-12 08:30:00	SPY	ETF	128.19	128.38	128.19	128.21	890464.0
2011-01-12 09:00:00	SPY	ETF	128.21	128.26	128.12	128.22	1036781.0
2011-01-12 09:30:00	SPY	ETF	128.21	128.26	127.99	128.1	10497212.0
2011-01-12 10:00:00	SPY	ETF	128.09	128.35	128.04	128.29	7018238.0
2011-01-12 10:30:00	SPY	ETF	128.2998	128.44	128.22	128.425	7924917.0
2011-01-12 11:00:00	SPY	ETF	128.425	128.67	128.4	128.56	10462072.0
2011-01-12 11:30:00	SPY	ETF	128.56	128.65	128.5475	128.56	5737850.0
2011-01-12 12:00:00	SPY	ETF	128.56	128.7	128.54	128.695	5409095.0
2011-01-12 12:30:00	SPY	ETF	128.7	128.72	128.51	128.51	6464818.0
2011-01-12 13:00:00	SPY	ETF	128.51	128.6	128.46	128.55	4063084.0
2011-01-12 13:30:00	SPY	ETF	128.56	128.62	128.53	128.61	2574978.0
2011-01-12 14:00:00	SPY	ETF	128.61	128.62	128.48	128.57	5633962.0
2011-01-12 14:30:00	SPY	ETF	128.56	128.6	128.48	128.55	5264334.0
2011-01-12 15:00:00	SPY	ETF	128.55	128.56	128.3	128.335	7702609.0
2011-01-12 15:30:00	SPY	ETF	128.34	128.6	128.32	128.6	15397704.0
2011-01-12 16:00:00	SPY	ETF	128.6	128.8	128.065	128.72	6589497.0
2011-01-12 16:30:00	SPY	ETF	128.71	128.71	128.4862	128.66	1197290.0
2011-01-12 17:00:00	SPY	ETF	128.67	128.73	128.66	128.67	159421.0
2011-01-12 17:30:00	SPY	ETF	128.67	128.72	128.67	128.69	14643.0
2011-01-12 18:00:00	SPY	ETF	128.69	128.69	128.6	128.6	535501.0
2011-01-12 18:30:00	SPY	ETF	128.59	128.66	128.59	128.63	14382.0
2011-01-12 19:00:00	SPY	ETF	128.66	128.66	128.63	128.66	9533.0
2011-01-12 19:30:00	SPY	ETF	128.67	128.69	128.62	128.68	25279.0
2011-01-12 04:00:00	QQQ	ETF	56.27	56.33	56.27	56.33	300.0
2011-01-12 04:30:00	QQQ	ETF	56.44	56.5	56.44	56.5	300.0
2011-01-12 05:00:00	QQQ	ETF	56.48	56.48	56.46	56.46	1400.0
2011-01-12 05:30:00	QQQ	ETF	56.46	56.46	56.45	56.46	2100.0
2011-01-12 06:00:00	QQQ	ETF	56.42	56.46	56.42	56.44	2350.0
2011-01-12 06:30:00	QQQ	ETF	56.42	56.45	56.42	56.43	11600.0
2011-01-12 07:00:00	QQQ	ETF	56.43	56.47	56.43	56.43	10450.0
2011-01-12 07:30:00	QQQ	ETF	56.45	56.45	56.39	56.44	49659.0
2011-01-12 08:00:00	QQQ	ETF	56.43	56.46	56.43	56.45	141926.0
2011-01-12 08:30:00	QQQ	ETF	56.46	56.52	56.41	56.42	191097.0
2011-01-12 09:00:00	QQQ	ETF	56.42	56.45	56.38	56.41	620972.0
2011-01-12 09:30:00	QQQ	ETF	56.42	56.43	56.2	56.29	6430128.0
2011-01-12 10:00:00	QQQ	ETF	56.3	56.36	56.24	56.35	4388540.0
2011-01-12 10:30:00	QQQ	ETF	56.34	56.4	56.33	56.39	2148530.0
2011-01-12 11:00:00	QQQ	ETF	56.39	56.51	56.38	56.465	5753069.0
2011-01-12 11:30:00	QQQ	ETF	56.46	56.52	56.46	56.46	1361445.0
2011-01-12 12:00:00	QQQ	ETF	56.46	56.51	56.42	56.51	1900903.0
2011-01-12 12:30:00	QQQ	ETF	56.505	56.51	56.4299	56.4299	1771619.0

> showing 50 of 9,400 rows — these rows as CSV

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