PREVIEW / etf_30min / 2009-07-16

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-16.parquet
  size:    223 KB
  rows:    7,277

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-07-16 04:00:00	SPY	ETF	92.65	92.65	92.65	92.65	700.0
2009-07-16 04:30:00	SPY	ETF	92.88	92.89	92.88	92.89	3000.0
2009-07-16 05:00:00	SPY	ETF	92.77	92.89	92.77	92.89	3500.0
2009-07-16 05:30:00	SPY	ETF	92.96	92.96	92.96	92.96	100.0
2009-07-16 06:00:00	SPY	ETF	92.83	93.04	92.83	92.99	47835.0
2009-07-16 06:30:00	SPY	ETF	93.04	93.35	93.04	93.26	64600.0
2009-07-16 07:00:00	SPY	ETF	93.18	93.25	92.88	93.04	470483.0
2009-07-16 07:30:00	SPY	ETF	93.04	93.11	92.86	92.86	557290.0
2009-07-16 08:00:00	SPY	ETF	92.87	93.33	92.87	93.3	2579667.0
2009-07-16 08:30:00	SPY	ETF	93.3	93.72	93.0	93.12	6612357.0
2009-07-16 09:00:00	SPY	ETF	93.12	93.17	92.97	92.99	1799685.0
2009-07-16 09:30:00	SPY	ETF	93.0	93.55	92.9	93.37	22307414.0
2009-07-16 10:00:00	SPY	ETF	93.37	93.38	92.82	93.175	20004883.0
2009-07-16 10:30:00	SPY	ETF	93.17	93.4	93.15	93.19	9696529.0
2009-07-16 11:00:00	SPY	ETF	93.19	93.34	92.97	93.04	7770820.0
2009-07-16 11:30:00	SPY	ETF	93.04	93.3	92.93	93.28	6638237.0
2009-07-16 12:00:00	SPY	ETF	93.28	93.32	93.2	93.32	6830280.0
2009-07-16 12:30:00	SPY	ETF	93.31	93.36	93.17	93.18	5103367.0
2009-07-16 13:00:00	SPY	ETF	93.18	93.25	93.04	93.12	8867730.0
2009-07-16 13:30:00	SPY	ETF	93.12	93.55	93.075	93.55	11008133.0
2009-07-16 14:00:00	SPY	ETF	93.55	93.9	93.47	93.82	22170940.0
2009-07-16 14:30:00	SPY	ETF	93.82	94.2	93.7232	94.06	18245567.0
2009-07-16 15:00:00	SPY	ETF	94.07	94.21	93.9	94.17	13095696.0
2009-07-16 15:30:00	SPY	ETF	94.17	94.51	94.07	94.16	34718943.0
2009-07-16 16:00:00	SPY	ETF	94.16	94.2222	93.96	94.0	14316198.0
2009-07-16 16:30:00	SPY	ETF	94.0	94.01	93.3655	93.3655	3400375.0
2009-07-16 17:00:00	SPY	ETF	93.91	93.93	93.79	93.79	353850.0
2009-07-16 17:30:00	SPY	ETF	93.79	93.87	93.75	93.8	44157.0
2009-07-16 18:00:00	SPY	ETF	93.81	93.86	93.11	93.11	60292.0
2009-07-16 18:30:00	SPY	ETF	93.85	93.86	93.84	93.85	4600.0
2009-07-16 19:00:00	SPY	ETF	93.85	93.85	93.82	93.83	5990.0
2009-07-16 19:30:00	SPY	ETF	93.83	93.84	93.77	93.79	17824.0
2009-07-16 05:30:00	QQQ	ETF	36.81	36.81	36.81	36.81	200.0
2009-07-16 06:00:00	QQQ	ETF	36.78	36.8	36.75	36.8	46600.0
2009-07-16 06:30:00	QQQ	ETF	36.79	36.87	36.79	36.87	8250.0
2009-07-16 07:00:00	QQQ	ETF	36.85	36.86	36.78	36.83	108400.0
2009-07-16 07:30:00	QQQ	ETF	36.84	36.86	36.79	36.79	190953.0
2009-07-16 08:00:00	QQQ	ETF	36.79	36.85	36.78	36.84	482637.0
2009-07-16 08:30:00	QQQ	ETF	36.84	36.92	36.7	36.72	2575514.0
2009-07-16 09:00:00	QQQ	ETF	36.72	36.78	36.7	36.73	577059.0
2009-07-16 09:30:00	QQQ	ETF	36.74	37.13	36.72	37.1	22662257.0
2009-07-16 10:00:00	QQQ	ETF	37.09	37.1	36.87	37.0174	14008642.0
2009-07-16 10:30:00	QQQ	ETF	37.02	37.1	36.9291	36.98	5434401.0
2009-07-16 11:00:00	QQQ	ETF	36.97	37.06	36.94	36.97	3446627.0
2009-07-16 11:30:00	QQQ	ETF	36.97	37.09	36.92	37.06	3902786.0
2009-07-16 12:00:00	QQQ	ETF	37.07	37.09	37.03	37.08	1726083.0
2009-07-16 12:30:00	QQQ	ETF	37.08	37.09	37.02	37.0201	2713559.0
2009-07-16 13:00:00	QQQ	ETF	37.02	37.06	36.99	37.03	2622102.0
2009-07-16 13:30:00	QQQ	ETF	37.0235	37.2	37.01	37.2	4988115.0
2009-07-16 14:00:00	QQQ	ETF	37.2	37.27	37.1505	37.238	7276236.0

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

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