PREVIEW / etf_30min / 2010-09-07

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-09-07.parquet
  size:    252 KB
  rows:    8,405

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
2010-09-07 04:00:00	SPY	ETF	110.66	110.66	110.15	110.17	8100.0
2010-09-07 04:30:00	SPY	ETF	110.26	110.41	110.25	110.41	5043.0
2010-09-07 05:00:00	SPY	ETF	110.33	110.33	110.25	110.32	2700.0
2010-09-07 05:30:00	SPY	ETF	110.3	110.39	110.3	110.35	7000.0
2010-09-07 06:00:00	SPY	ETF	110.3	110.3	110.16	110.16	52992.0
2010-09-07 06:30:00	SPY	ETF	110.24	110.34	110.21	110.33	32822.0
2010-09-07 07:00:00	SPY	ETF	110.33	110.37	110.17	110.22	229472.0
2010-09-07 07:30:00	SPY	ETF	110.24	110.42	110.07	110.38	247584.0
2010-09-07 08:00:00	SPY	ETF	110.38	110.8	110.16	110.16	2794899.0
2010-09-07 08:30:00	SPY	ETF	110.17	110.33	110.15	110.26	369874.0
2010-09-07 09:00:00	SPY	ETF	110.25	110.43	110.25	110.37	776397.0
2010-09-07 09:30:00	SPY	ETF	110.37	110.51	109.86	109.87	20864818.0
2010-09-07 10:00:00	SPY	ETF	109.871	110.06	109.74	109.99	13900862.0
2010-09-07 10:30:00	SPY	ETF	109.99	110.11	109.84	110.05	8139593.0
2010-09-07 11:00:00	SPY	ETF	110.05	110.14	109.83	110.1	8748879.0
2010-09-07 11:30:00	SPY	ETF	110.1	110.19	109.87	110.15	6610531.0
2010-09-07 12:00:00	SPY	ETF	110.15	110.23	109.96	110.03	5457794.0
2010-09-07 12:30:00	SPY	ETF	110.02	110.06	109.88	109.9701	3960583.0
2010-09-07 13:00:00	SPY	ETF	109.975	110.02	109.83	109.93	5731048.0
2010-09-07 13:30:00	SPY	ETF	109.93	110.17	109.91	110.1599	4977262.0
2010-09-07 14:00:00	SPY	ETF	110.16	110.23	110.0	110.08	5430995.0
2010-09-07 14:30:00	SPY	ETF	110.09	110.11	109.62	109.71	10998605.0
2010-09-07 15:00:00	SPY	ETF	109.7	109.84	109.6	109.785	9499112.0
2010-09-07 15:30:00	SPY	ETF	109.79	109.93	109.55	109.67	20175567.0
2010-09-07 16:00:00	SPY	ETF	109.68	110.972	109.661	109.74	9146802.0
2010-09-07 16:30:00	SPY	ETF	109.72	110.9273	109.61	109.69	959427.0
2010-09-07 17:00:00	SPY	ETF	109.69	109.72	109.65	109.72	131277.0
2010-09-07 17:30:00	SPY	ETF	109.74	109.74	109.71	109.72	26996.0
2010-09-07 18:00:00	SPY	ETF	109.71	109.71	109.63	109.65	110416.0
2010-09-07 18:30:00	SPY	ETF	109.65	109.69	109.63	109.67	15510.0
2010-09-07 19:00:00	SPY	ETF	109.67	109.73	109.65	109.71	12393.0
2010-09-07 19:30:00	SPY	ETF	109.75	109.76	109.66	109.67	14114.0
2010-09-07 04:00:00	QQQ	ETF	45.83	45.85	45.75	45.82	9731.0
2010-09-07 04:30:00	QQQ	ETF	45.83	45.85	45.79	45.85	11271.0
2010-09-07 05:00:00	QQQ	ETF	45.85	45.85	45.8	45.8	5440.0
2010-09-07 05:30:00	QQQ	ETF	45.8	45.8	45.8	45.8	6000.0
2010-09-07 06:30:00	QQQ	ETF	45.75	45.8	45.75	45.8	10446.0
2010-09-07 07:00:00	QQQ	ETF	45.8	45.82	45.67	45.68	655755.0
2010-09-07 07:30:00	QQQ	ETF	45.68	45.72	45.64	45.72	213243.0
2010-09-07 08:00:00	QQQ	ETF	45.77	45.8	45.68	45.69	1849269.0
2010-09-07 08:30:00	QQQ	ETF	45.7	45.79	45.69	45.77	342410.0
2010-09-07 09:00:00	QQQ	ETF	45.78	45.85	45.76	45.82	697705.0
2010-09-07 09:30:00	QQQ	ETF	45.82	46.03	45.73	45.73	9292940.0
2010-09-07 10:00:00	QQQ	ETF	45.73	45.82	45.66	45.785	5129593.0
2010-09-07 10:30:00	QQQ	ETF	45.785	45.85	45.7	45.8201	2740179.0
2010-09-07 11:00:00	QQQ	ETF	45.82	45.86	45.72	45.83	2159246.0
2010-09-07 11:30:00	QQQ	ETF	45.84	45.87	45.73	45.845	2573742.0
2010-09-07 12:00:00	QQQ	ETF	45.84	45.88	45.75	45.7799	1625779.0
2010-09-07 12:30:00	QQQ	ETF	45.78	45.8	45.7	45.76	1757063.0
2010-09-07 13:00:00	QQQ	ETF	45.76	45.79	45.69	45.72	2071323.0

> showing 50 of 8,405 rows — these rows as CSV

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