PREVIEW / etf_30min / 2011-12-01

all etf 30-min files

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

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-12-01 04:00:00	SPY	ETF	124.68	124.68	124.33	124.48	11750.0
2011-12-01 04:30:00	SPY	ETF	124.53	124.79	124.53	124.79	3100.0
2011-12-01 05:00:00	SPY	ETF	124.83	124.95	124.79	124.79	7880.0
2011-12-01 05:30:00	SPY	ETF	124.77	124.93	124.68	124.93	14600.0
2011-12-01 06:00:00	SPY	ETF	124.93	124.93	124.51	124.73	80300.0
2011-12-01 06:30:00	SPY	ETF	124.69	124.86	124.66	124.86	34400.0
2011-12-01 07:00:00	SPY	ETF	124.78	125.02	124.77	124.93	95059.0
2011-12-01 07:30:00	SPY	ETF	124.94	125.15	124.9	125.07	534563.0
2011-12-01 08:00:00	SPY	ETF	125.05	125.29	124.35	125.24	1132271.0
2011-12-01 08:30:00	SPY	ETF	125.16	125.2	124.71	124.95	1921202.0
2011-12-01 09:00:00	SPY	ETF	124.95	125.11	124.78	124.85	1506649.0
2011-12-01 09:30:00	SPY	ETF	124.85	125.4	124.7099	125.34	24203982.0
2011-12-01 10:00:00	SPY	ETF	125.34	125.64	125.13	125.405	21330202.0
2011-12-01 10:30:00	SPY	ETF	125.4	125.4	124.86	124.92	12304620.0
2011-12-01 11:00:00	SPY	ETF	124.91	125.12	124.52	124.59	15692559.0
2011-12-01 11:30:00	SPY	ETF	124.59	124.93	124.43	124.88	13261874.0
2011-12-01 12:00:00	SPY	ETF	124.89	124.95	124.72	124.9	7032427.0
2011-12-01 12:30:00	SPY	ETF	124.89	124.99	124.47	124.48	7235058.0
2011-12-01 13:00:00	SPY	ETF	124.48	124.91	124.47	124.89	5935909.0
2011-12-01 13:30:00	SPY	ETF	124.88	125.34	124.86	125.33	8699010.0
2011-12-01 14:00:00	SPY	ETF	125.3292	125.34	124.98	125.12	6954701.0
2011-12-01 14:30:00	SPY	ETF	125.12	125.28	124.96	125.0798	6616815.0
2011-12-01 15:00:00	SPY	ETF	125.07	125.25	124.82	125.25	10016360.0
2011-12-01 15:30:00	SPY	ETF	125.25	125.27	124.7	124.97	19312626.0
2011-12-01 16:00:00	SPY	ETF	124.96	125.0	124.73	124.94	8329730.0
2011-12-01 16:30:00	SPY	ETF	124.93	124.93	124.82	124.89	1762521.0
2011-12-01 17:00:00	SPY	ETF	124.89	124.98	124.86	124.89	81625.0
2011-12-01 17:30:00	SPY	ETF	124.87	124.93	124.87	124.9	43781.0
2011-12-01 18:00:00	SPY	ETF	124.9	124.98	124.83	124.83	125533.0
2011-12-01 18:30:00	SPY	ETF	124.83	124.97	124.8	124.94	91858.0
2011-12-01 19:00:00	SPY	ETF	124.97	125.21	124.93	125.21	165893.0
2011-12-01 19:30:00	SPY	ETF	125.21	125.29	125.11	125.22	78008.0
2011-12-01 04:00:00	QQQ	ETF	56.2	56.31	56.2	56.31	4085.0
2011-12-01 05:00:00	QQQ	ETF	56.43	56.43	56.43	56.43	500.0
2011-12-01 06:00:00	QQQ	ETF	56.41	56.41	56.32	56.35	6600.0
2011-12-01 06:30:00	QQQ	ETF	56.39	56.44	56.36	56.43	5700.0
2011-12-01 07:00:00	QQQ	ETF	56.43	56.48	56.43	56.44	4850.0
2011-12-01 07:30:00	QQQ	ETF	56.44	56.53	56.42	56.49	8300.0
2011-12-01 08:00:00	QQQ	ETF	56.49	56.59	56.48	56.57	82427.0
2011-12-01 08:30:00	QQQ	ETF	56.52	56.52	56.36	56.42	80668.0
2011-12-01 09:00:00	QQQ	ETF	56.42	56.43	56.37	56.39	186805.0
2011-12-01 09:30:00	QQQ	ETF	56.38	56.81	56.35	56.76	5657436.0
2011-12-01 10:00:00	QQQ	ETF	56.76	56.88	56.66	56.73	5082846.0
2011-12-01 10:30:00	QQQ	ETF	56.72	56.72	56.44	56.48	3120286.0
2011-12-01 11:00:00	QQQ	ETF	56.49	56.64	56.37	56.43	3010786.0
2011-12-01 11:30:00	QQQ	ETF	56.42	56.625	56.35	56.62	3182051.0
2011-12-01 12:00:00	QQQ	ETF	56.62	56.72	56.54	56.67	2104774.0
2011-12-01 12:30:00	QQQ	ETF	56.67	56.71	56.49	56.51	1253542.0
2011-12-01 13:00:00	QQQ	ETF	56.51	56.66	56.5	56.65	1081681.0
2011-12-01 13:30:00	QQQ	ETF	56.65	56.85	56.62	56.845	1864110.0

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

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