PREVIEW / etf_30min / 2009-11-05

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-11-05.parquet
  size:    233 KB
  rows:    7,717

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
2009-11-05 04:30:00	SPY	ETF	105.05	105.17	105.03	105.12	1200.0
2009-11-05 05:30:00	SPY	ETF	105.05	105.05	105.05	105.05	100.0
2009-11-05 06:00:00	SPY	ETF	105.2	105.25	105.15	105.15	1500.0
2009-11-05 06:30:00	SPY	ETF	105.1	105.2	105.1	105.2	50800.0
2009-11-05 07:00:00	SPY	ETF	105.12	105.37	105.09	105.36	626868.0
2009-11-05 07:30:00	SPY	ETF	105.36	105.46	105.34	105.4	529793.0
2009-11-05 08:00:00	SPY	ETF	105.18	105.43	105.15	105.43	3809636.0
2009-11-05 08:30:00	SPY	ETF	105.43	105.76	104.91	105.6	2706753.0
2009-11-05 09:00:00	SPY	ETF	105.6	105.84	104.91	105.65	2385158.0
2009-11-05 09:30:00	SPY	ETF	105.66	106.15	105.44	106.09	27578134.0
2009-11-05 10:00:00	SPY	ETF	106.1	106.33	105.96	106.12	16205640.0
2009-11-05 10:30:00	SPY	ETF	106.12	106.66	106.12	106.5925	15518515.0
2009-11-05 11:00:00	SPY	ETF	106.59	106.67	106.36	106.48	12603728.0
2009-11-05 11:30:00	SPY	ETF	106.48	106.67	106.07	106.11	9134155.0
2009-11-05 12:00:00	SPY	ETF	106.11	106.49	106.07	106.27	8100710.0
2009-11-05 12:30:00	SPY	ETF	106.27	106.58	106.16	106.57	7009866.0
2009-11-05 13:00:00	SPY	ETF	106.57	106.65	106.44	106.46	5457704.0
2009-11-05 13:30:00	SPY	ETF	106.46	106.77	106.43	106.4601	7810517.0
2009-11-05 14:00:00	SPY	ETF	106.46	106.53	106.31	106.431	8062942.0
2009-11-05 14:30:00	SPY	ETF	106.44	106.75	106.35	106.68	6855055.0
2009-11-05 15:00:00	SPY	ETF	106.68	106.84	106.56	106.68	9272850.0
2009-11-05 15:30:00	SPY	ETF	106.68	106.88	106.51	106.86	23725548.0
2009-11-05 16:00:00	SPY	ETF	106.85	106.8896	105.61	106.84	6549960.0
2009-11-05 16:30:00	SPY	ETF	106.84	106.9	104.8463	106.86	5154310.0
2009-11-05 17:00:00	SPY	ETF	106.86	106.93	106.16	106.87	147032.0
2009-11-05 17:30:00	SPY	ETF	106.86	106.88	106.84	106.84	71413.0
2009-11-05 18:00:00	SPY	ETF	106.86	106.88	106.12	106.82	70466.0
2009-11-05 18:30:00	SPY	ETF	106.83	106.83	106.75	106.8	70825.0
2009-11-05 19:00:00	SPY	ETF	106.76	106.78	106.75	106.77	34996.0
2009-11-05 19:30:00	SPY	ETF	106.78	106.85	106.77	106.78	28183.0
2009-11-05 04:00:00	QQQ	ETF	41.27	41.27	41.27	41.27	100.0
2009-11-05 04:30:00	QQQ	ETF	41.31	41.4	41.31	41.4	700.0
2009-11-05 07:00:00	QQQ	ETF	41.44	41.65	41.44	41.65	444727.0
2009-11-05 07:30:00	QQQ	ETF	41.65	41.73	41.65	41.69	739769.0
2009-11-05 08:00:00	QQQ	ETF	41.69	41.71	41.48	41.71	4364580.0
2009-11-05 08:30:00	QQQ	ETF	41.72	41.84	41.69	41.79	3174720.0
2009-11-05 09:00:00	QQQ	ETF	41.78	41.86	41.78	41.81	1256858.0
2009-11-05 09:30:00	QQQ	ETF	41.8	42.13	41.78	42.0999	16752151.0
2009-11-05 10:00:00	QQQ	ETF	42.1	42.19	42.07	42.16	10575136.0
2009-11-05 10:30:00	QQQ	ETF	42.16	42.4	42.15	42.335	11209960.0
2009-11-05 11:00:00	QQQ	ETF	42.35	42.38	42.26	42.28	6539604.0
2009-11-05 11:30:00	QQQ	ETF	42.28	42.3	42.15	42.15	3858762.0
2009-11-05 12:00:00	QQQ	ETF	42.158	42.31	42.15	42.2	4801509.0
2009-11-05 12:30:00	QQQ	ETF	42.2	42.3	42.17	42.3	2214841.0
2009-11-05 13:00:00	QQQ	ETF	42.2991	42.31	42.21	42.245	2444585.0
2009-11-05 13:30:00	QQQ	ETF	42.24	42.37	42.23	42.26	3092002.0
2009-11-05 14:00:00	QQQ	ETF	42.26	42.3	42.22	42.27	3501240.0
2009-11-05 14:30:00	QQQ	ETF	42.28	42.35	42.23	42.32	5742998.0
2009-11-05 15:00:00	QQQ	ETF	42.32	42.36	42.25	42.28	2404840.0
2009-11-05 15:30:00	QQQ	ETF	42.28	42.36	42.2	42.35	9123542.0

> showing 50 of 7,717 rows — these rows as CSV

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