PREVIEW / etf_30min / 2011-12-30

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-12-30.parquet
  size:    280 KB
  rows:    9,531

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-30 05:00:00	SPY	ETF	126.15	126.19	126.15	126.19	7700.0
2011-12-30 05:30:00	SPY	ETF	126.21	126.25	126.21	126.25	101318.0
2011-12-30 06:00:00	SPY	ETF	126.3	126.31	126.28	126.31	600.0
2011-12-30 06:30:00	SPY	ETF	126.28	126.3	126.21	126.27	17090.0
2011-12-30 07:00:00	SPY	ETF	126.31	126.44	126.27	126.38	50640.0
2011-12-30 07:30:00	SPY	ETF	126.4	126.45	126.34	126.39	44650.0
2011-12-30 08:00:00	SPY	ETF	126.4	126.45	125.95	126.36	194755.0
2011-12-30 08:30:00	SPY	ETF	126.37	126.38	126.1	126.19	277768.0
2011-12-30 09:00:00	SPY	ETF	126.18	126.24	125.98	126.0	1079172.0
2011-12-30 09:30:00	SPY	ETF	126.02	126.2	125.89	126.169	11368905.0
2011-12-30 10:00:00	SPY	ETF	126.16	126.33	126.02	126.08	6107867.0
2011-12-30 10:30:00	SPY	ETF	126.08	126.21	126.02	126.11	4998530.0
2011-12-30 11:00:00	SPY	ETF	126.11	126.25	126.06	126.21	5176202.0
2011-12-30 11:30:00	SPY	ETF	126.22	126.245	126.02	126.02	3994120.0
2011-12-30 12:00:00	SPY	ETF	126.021	126.09	125.97	126.01	3321524.0
2011-12-30 12:30:00	SPY	ETF	126.0	126.1	125.99	126.055	2121392.0
2011-12-30 13:00:00	SPY	ETF	126.04	126.08	125.98	126.0	1895205.0
2011-12-30 13:30:00	SPY	ETF	125.997	126.07	125.98	126.039	1724713.0
2011-12-30 14:00:00	SPY	ETF	126.04	126.04	125.68	125.77	4682645.0
2011-12-30 14:30:00	SPY	ETF	125.77	125.859	125.77	125.83	5837358.0
2011-12-30 15:00:00	SPY	ETF	125.83	126.1966	125.83	125.95	6102195.0
2011-12-30 15:30:00	SPY	ETF	125.95	125.98	125.59	125.59	19232833.0
2011-12-30 16:00:00	SPY	ETF	125.6	126.1966	125.5	125.66	13359072.0
2011-12-30 16:30:00	SPY	ETF	125.66	125.67	125.45	125.5	310524.0
2011-12-30 17:00:00	SPY	ETF	125.51	125.65	125.49	125.63	132686.0
2011-12-30 17:30:00	SPY	ETF	125.64	125.64	125.58	125.62	11034.0
2011-12-30 18:00:00	SPY	ETF	125.61	125.62	125.5	125.62	17175.0
2011-12-30 18:30:00	SPY	ETF	125.58	125.61	125.4	125.4	140869.0
2011-12-30 19:00:00	SPY	ETF	125.45	125.5	125.25	125.38	103682.0
2011-12-30 19:30:00	SPY	ETF	125.38	125.49	125.38	125.43	64272.0
2011-12-30 06:30:00	QQQ	ETF	55.93	55.96	55.93	55.96	2300.0
2011-12-30 07:30:00	QQQ	ETF	56.04	56.04	56.02	56.03	5900.0
2011-12-30 08:00:00	QQQ	ETF	56.05	56.05	55.97	55.97	7700.0
2011-12-30 08:30:00	QQQ	ETF	55.98	55.99	55.9	55.91	65242.0
2011-12-30 09:00:00	QQQ	ETF	55.91	55.96	55.86	55.86	158693.0
2011-12-30 09:30:00	QQQ	ETF	55.86	56.07	55.86	56.065	1851180.0
2011-12-30 10:00:00	QQQ	ETF	56.065	56.12	55.985	56.01	1525751.0
2011-12-30 10:30:00	QQQ	ETF	56.01	56.07	55.95	56.02	1162762.0
2011-12-30 11:00:00	QQQ	ETF	56.01	56.1	56.01	56.07	912474.0
2011-12-30 11:30:00	QQQ	ETF	56.075	56.1	56.0135	56.02	1094027.0
2011-12-30 12:00:00	QQQ	ETF	56.01	56.05	55.98	56.02	578920.0
2011-12-30 12:30:00	QQQ	ETF	56.01	56.07	56.01	56.0502	518387.0
2011-12-30 13:00:00	QQQ	ETF	56.06	56.08	56.02	56.02	528234.0
2011-12-30 13:30:00	QQQ	ETF	56.025	56.06	56.02	56.03	670920.0
2011-12-30 14:00:00	QQQ	ETF	56.03	56.039	55.86	55.9	1775178.0
2011-12-30 14:30:00	QQQ	ETF	55.9004	55.94	55.9	55.91	636817.0
2011-12-30 15:00:00	QQQ	ETF	55.92	55.99	55.915	55.95	2108963.0
2011-12-30 15:30:00	QQQ	ETF	55.95	55.96	55.82	55.829	5537066.0
2011-12-30 16:00:00	QQQ	ETF	55.83	55.94	55.78	55.85	1706363.0
2011-12-30 16:30:00	QQQ	ETF	55.87	55.87	55.77	55.77	25878.0

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

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